June 12, 2023 asghars
- 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