Tags » DAX

NaturalInnerJoin And NaturalLeftOuterJoin DAX Functions In Excel 2016

Continuing my series on new DAX functions in Excel 2016, here are two more: NaturalInnerJoin() and NaturalLeftOuterJoin(). Both do pretty much what you’d expect.

Consider the following two tables in an Excel worksheet, called ColourFruit and FruitPrice: 159 more words

PowerPivot

Sending Email from AX

Sending Email from AX

static void EmailAlert(Args _args)
{
  // Set these variables.
    str                                   sender = 'Ax Mail Id';//From the parameter form
    str                                   recipient = 'Mail Id's';
  //str                                   cc = 'Mail Id's';
    str                                   subject = 'Test1';
    str                                   body = 'Test1';
  //str                                   fileName = @'C:\test.txt';

    List                                  toList;
    List                                  ccList;
    ListEnumerator                        le;

    Set                                   permissionSet;
    System.Exception                      e;

    str                                   mailServer;
    int                                   mailServerPort;
    System.Net.Mail.SmtpClient            mailClient;
    System.Net.Mail.MailMessage           mailMessage;
    System.Net.Mail.MailAddress           mailFrom;
    System.Net.Mail.MailAddress           mailTo;
    System.Net.Mail.MailAddressCollection mailToCollection;
    System.Net.Mail.MailAddressCollection mailCCCollection;
    System.Net.Mail.AttachmentCollection  mailAttachementCollection;
    System.Net.Mail.Attachment            mailAttachment;
    ;

    try
    {
        toList = strSplit(recipient, ';');
        //ccList = strSplit(cc, ';');

        permissionSet = new Set(Types::Class);
        permissionSet.add(new InteropPermission(InteropKind::ClrInterop));
       // permissionSet.add(new FileIOPermission(filename, 'rw'));
        CodeAccessPermission::assertMultiple(permissionSet);

        mailServer = SysEmaiLParameters::find(false).SMTPRelayServerName;
        mailServerPort = SysEmaiLParameters::find(false).SMTPPortNumber;
        mailClient = new System.Net.Mail.SmtpClient(mailServer, mailServerPort);

        le = toList.getEnumerator();
        le.moveNext();

        mailFrom = new System.Net.Mail.MailAddress(sender);
        mailTo  = new System.Net.Mail.MailAddress(strLTrim(strRTrim(le.current())));
        mailMessage = new System.Net.Mail.MailMessage(mailFrom, mailTo);

        mailToCollection = mailMessage.get_To();
        while (le.moveNext())
        {
            mailToCollection.Add(strLTrim(strRTrim(le.current())));
        }

     //   le = ccList.getEnumerator();
     //   mailCCCollection = mailMessage.get_CC();
     //   while (le.moveNext())
     //   {
     //       mailCCCollection.Add(strLTrim(strRTrim(le.current())));
     //   }

        mailMessage.set_Priority(System.Net.Mail.MailPriority::High);
        mailMessage.set_Subject(subject);
        mailMessage.set_Body(body);

        //mailAttachementCollection = mailMessage.get_Attachments();
       // mailAttachment = new System.Net.Mail.Attachment(fileName);
       // mailAttachementCollection.Add(mailAttachment);

        mailClient.Send(mailMessage);
        mailMessage.Dispose();

        CodeAccessPermission::revertAssert();

        info("Email sent.");
    }
    catch (Exception::CLRError)
    {
        e = ClrInterop::getLastException();
        while (e)
        {
            info(e.get_Message());
            e = e.get_InnerException();
        }
        CodeAccessPermission::revertAssert();
    }
}
Ax2012

The Whisperer

The structure (see also: The Army of the 12 Monkeys) we have been following continues to work brilliantly with overnight up gap action permitting another very profitable scale out. 808 more words

Premium Content

Analysis Services | Tabular Model - DAX ( Dynamic Analysis Expressions )

DAX Quick Reference

Data Analysis Expressions (DAX) is the formula language used to create custom calculations in Microsoft PowerPivot for Microsoft Excel workbooks and SQL Server 2012 Analysis Services (SSAS) tabular model projects. 382 more words

Queries For SQL Interview

Saturday 28th March

Saturday 28th. March

Price action on Friday was contained within a symmetrical triangle and the daily candlestick was a Doji.

Based on this we have no directional bias. 56 more words

Market tops everywhere $SPX $DIA $DJT $NBI #markets #stocks #trendfollowing #trading #investing

S&P-500 yearly

Dow Jones Average yearly

Dow Jones Transportation yearly

NASDAQ Biotechnology Index yearly

DAX yearly

-

Heikin-ashi