Code never lies, comments sometimes do [Ron Jeffries]

Visitors Map

Follow on Twitter

@ZammaCode
Powered by Blogger.

Monday, June 12, 2023

What is Data Analysis Expressions (DAX)


  • DAX is a functional and, query language.
  • Functional means DAX primarily use functions to generate results.
  • Query means DAX can only filter or query data from table in Power BI, SSAS Tabular or PowerPivot.
  • DAX is used in:
    • Measures
      • Measure is a calculated value or expression that performs some calculation on the data to derive meaningful insights.
    • Calculated columns
      • Calculated column is a column that is created in a table by defining a DAX formula or expression. 
    • Calculated tables
      • Calculated table is derived from calculations based on existing tables or columns in the data model. 
    • Row-level security
      • In Row-level security the DAX formulas are used for creating an allowed row set.



0 comments:

Post a Comment