locked
DAX's level of Business Logic RRS feed

  • Question

  • -- From what I have seen about DAX's ability, is it used for doing advanced business logic to be enable to do advanced calculation in the same level as a C sharp developer?

    -- Would you see that DAX's code level of business logic would be the same for Excel calculation (not Excel VBA)?

    Monday, May 20, 2013 1:40 PM

Answers

  • Hi Sakura,

    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. DAX formulas include functions, operators, and values to perform advanced calculations on relational tables and columns, including lookups to related values and related tables.

    I recommend you take a look at the following article:
    Understanding DAX in Tabular Models (SSAS Tabular): http://technet.microsoft.com/en-us/library/hh213101.aspx

    Best Regards,


    Elvis Long
    TechNet Community Support

    • Marked as answer by Sakura Data Thursday, May 23, 2013 10:51 AM
    Wednesday, May 22, 2013 3:40 AM