Types of DAX Functions in Power BI

Quality AI needs quality data - get AI-ready with SyncHub

In Power BI, DAX (Data Analysis Expressions) functions are categorized into several types based on their functionality. Below are the main types of DAX functions:

1. Aggregation Functions

• Perform calculations on a column or table.
• Examples: SUM(), AVERAGE(), MIN(), MAX(), COUNT(), DISTINCTCOUNT().

2. Logical Functions

• Used to evaluate conditions and return boolean results.
• Examples: IF(), SWITCH(), AND(), OR(), NOT().

3. Date & Time Functions

• Work with dates and time-based calculations.
• Examples: TODAY(), NOW(), YEAR(), MONTH(), DATEDIFF(), EDATE(), EOMONTH().

4. Text Functions

• Manipulate text values.
• Examples: LEFT(), RIGHT(), MID(), CONCATENATE(), SUBSTITUTE(), SEARCH(), LEN().

5. Filter Functions

• Help filter data within calculations.
• Examples: FILTER(), ALL(), ALLEXCEPT(), ALLSELECTED(), KEEPFILTERS().

6. Information Functions

• Return information about the data type or value.
• Examples: ISBLANK(), ISNUMBER(), ISTEXT(), ISERROR(), HASONEVALUE().

7. Parent-Child Functions

• Used for hierarchical data structures.
• Examples: PATH(), PATHITEM(), PATHLENGTH().

8. Mathematical & Trigonometric Functions

• Perform mathematical calculations.
• Examples: ROUND(), CEILING(), FLOOR(), SQRT(), EXP(), LOG().

9. Statistical Functions

• Used for statistical analysis.
• Examples: MEDIAN(), VAR(), STDEV(), PERCENTILE.EXC().

10. Time Intelligence Functions

• Work with time-based calculations (year-over-year, month-to-date, etc.).
• Examples: TOTALYTD(), TOTALMTD(), PREVIOUSMONTH(), SAMEPERIODLASTYEAR(), DATESBETWEEN(), DATEADD().

Quality AI needs quality data - get AI-ready with SyncHub