DEV Community

Punitha
Punitha

Posted on

Data Analysis Expressions(DAX)

What is DAX?

  • DAX(Data Analysis Expressions) is a formula language used in Power BI to create calculated columns, measures, and custom calculations.

  • DAX helps users perform advanced data analysis and create business metrics.

Why DAX is Used?

  • Perform calculations

  • Create KPIs

  • Calculate totals and average

  • Analyze trends

  • Create custom business metrics

How to Create a DAX Measure?

  • Step 1:
    Modeling -> New Measure

  • Step 2:
    Write the DAX formula

  • Step 3:
    Press Enter

  • Step 4:
    Use the measure in visuals

Common DAX Functions

  • SUM() - Calculates the total value 
Total Sales = SUM(Sales[Sales Amount])
Enter fullscreen mode Exit fullscreen mode
  • AVERAGE() - Calculates the average value 
Average Salary = AVERAGE(Employee[Salary])
Enter fullscreen mode Exit fullscreen mode
  • COUNT() - Counts the numbers of records 
Total Orders = COUNT(Orders[Order ID])
Enter fullscreen mode Exit fullscreen mode
  • MAX() - Returns the highest value 
Highest Sales = MAX(Sales[Sales Amount])
Enter fullscreen mode Exit fullscreen mode
  • MIN() - Returns the lowest value 
Lowest Sales = MIN([Sales[Sales Amount])
Enter fullscreen mode Exit fullscreen mode

Top comments (0)