Practicing Dax Calculations

Data Model:

AGGREGATION FUNCTIONS

1. SUM

Total Sales = SUM('Sales Orders'[Total Revenue])

2. AVERAGE

Average sales = AVERAGE('Sales Orders'[Total Revenue])

3. MIN

Min sales = MIN('Sales Orders'[Total Revenue])

4. MAX

Max sales = MAX('Sales Orders'[Total Revenue])

5. COUNT

Number of Transactions = COUNT(Sales[OrderNumber])

6. COUNTROWS

Total transactions = COUNTROWS('Sales Orders')

7. COUNTBLANK

Total Blank = COUNTBLANK(Sales[Order Quantity])

8. COUNTA

Total Transactions 2 = COUNTA(Sales[Order Quantity])

9. DISTINCTCOUNT

No of Products = DISTINCTCOUNT(Products[Product Name])

ITERATIVE FUNCTIONS

1. AVERAGEX

Average Sales 2 =
AVERAGEX ( Sales, Sales[Total Revenue] )

2. SUMX

Total Sales 2 = 
SUMX ( Sales, Sales[Total Revenue])

3. MINX

Min Sales 2 = 
MINX( Sales, Sales[Total Revenue])

4. MAXX

Max Sales 2 = 
MAXX( Sales, Sales[Total Revenue])

LOGICAL FUNCTIONS

1. IF

High Sales 1 = IF([Total Sales]>20000, "High", "Low")

2. SWITCH

High Sales 2 =
SWITCH (
TRUE (),
[Total Sales] <= 20000, "Low",
[Total Sales 2] > 20000, "High",
BLANK ()
)

DIVIDE FUNCTION

Profit Margin = DIVIDE( [Total Profit], [Total Sales], 0)

TIME INTELLIGENCE FUNCTIONS

1. Sales Last year =
CALCULATE ( [Total Sales], DATEADD ( Dates[Date], -1, YEAR ) )

2. Sales Last Month =
CALCULATE ( [Total Sales], DATEADD ( Dates[Date], -1, MONTH ) )

3. Month to Month Growth = 
DIVIDE (
    [Total Sales],
    CALCULATE ( [Total Sales], DATEADD ( Dates[Date], -1, MONTH ) ),
0
)

4. Day to Day Growth = 
DIVIDE (
    [Total Sales],
    CALCULATE ( [Total Sales], DATEADD ( Dates[Date], -1, DAY ) ),
0
)