Quick Power BI Dax Revision

1. Measures: Measures in DAX are calculations that are used in Power BI to perform aggregations, calculations, and comparisons on data. They are defined using the DEFINE MEASURE or CALCULATE functions.

2. Calculated Columns: Calculated columns are columns that are created in a table by using DAX expressions. They are calculated row by row when the data is loaded into the model.

3. DAX Functions: DAX provides a wide range of functions for data manipulation and calculation. Some common functions include SUM, AVERAGE, COUNT, FILTER, CALCULATE, RELATED, ALL, ALLEXCEPT, and many more.

4. Context: DAX calculations are performed within a context, which can be row context or filter context. Understanding how context works is crucial for writing accurate DAX expressions.

5. Relationships: Power BI data models are built on relationships between tables. DAX expressions can leverage these relationships to perform calculations across related tables.

6. Time Intelligence Functions: DAX includes a set of time intelligence functions that enable you to perform calculations based on dates and time periods. Examples include TOTALYTD, SAMEPERIODLASTYEAR, DATESBETWEEN, etc.

7. Variables: DAX allows you to declare and use variables within expressions to improve readability and performance of complex calculations.

8. Aggregation Functions: DAX provides aggregation functions like SUMX, AVERAGEX, COUNTX that allow you to iterate over a table and perform aggregations based on specified conditions.

9. Logical Functions: DAX includes logical functions such as IF, AND, OR, SWITCH that help in implementing conditional logic within calculations.

10. Error Handling: DAX provides functions like ISBLANK, IFERROR, BLANK, etc., for handling errors and missing data in calculations.