Frequently used DAX function

Here are some of the most frequently used DAX (Data Analysis Expressions) functions in Power BI:

  1. SUM: calculates the sum of a set of values
  2. AVERAGE: calculates the average of a set of values
  3. COUNT: counts the number of items in a set
  4. MIN: returns the minimum value in a set
  5. MAX: returns the maximum value in a set
  6. IF: returns one value if a condition is true and another value if it’s false
  7. TODAY: returns the current date
  8. NOW: returns the current date and time
  9. LEFT: returns a specified number of characters from the start of a text string
  10. RIGHT: returns a specified number of characters from the end of a text string

These are just a few of the many DAX functions available in Power BI, and the specific functions you use will depend on your data and analysis requirements.

Scroll to Top