Forum Discussion

mapman1980's avatar
mapman1980
Regular Visitor
3 years ago
Solved

Quarterly Growth Calculation

Hello!   I'm calculating the average growth rates of some sale values for each quarter. I had to convert the quarters into numeric values to get it to work though.    Here is the measure I used:...
DAX
Growth
label
measure
  • johnt75's avatar
    johnt75
    3 years ago

    Set up a proper date table, marked as a date table, and you can use

    Growth Rate from Average Sales =
VAR CurrentQuarterSales =
    CALCULATE ( AVERAGE ( Assets[Sales] ), DATESQTD ( 'Date'[Date] ) )
VAR PreviousQuarterSales =
    CALCULATE (
        AVERAGE ( Assets[Sales] ),
        DATEADD ( DATESQTD ( 'Date'[Date] ), -1, QUARTER )
    )
RETURN
    IF (
        ISBLANK ( CurrentQuarterSales ) || ISBLANK ( PreviousQuarterSales ),
        BLANK (),
        DIVIDE ( CurrentQuarterSales - PreviousQuarterSales, PreviousQuarterSales )
    )
johnt75's avatar
johnt75
Super User
3 years ago

Set up a proper date table, marked as a date table, and you can use

Growth Rate from Average Sales =
VAR CurrentQuarterSales =
    CALCULATE ( AVERAGE ( Assets[Sales] ), DATESQTD ( 'Date'[Date] ) )
VAR PreviousQuarterSales =
    CALCULATE (
        AVERAGE ( Assets[Sales] ),
        DATEADD ( DATESQTD ( 'Date'[Date] ), -1, QUARTER )
    )
RETURN
    IF (
        ISBLANK ( CurrentQuarterSales ) || ISBLANK ( PreviousQuarterSales ),
        BLANK (),
        DIVIDE ( CurrentQuarterSales - PreviousQuarterSales, PreviousQuarterSales )
    )
mapman1980's avatar
mapman1980
Regular Visitor
3 years ago

Thank you very much, that works perfectly and just as intended.