DAX - Compare Actual month vs January

[armand453]

Hello,

I have a table with revenue by month on several year and i'd like to compare the growth of the revenu of the current month vs january of the same year. Is it possible to do that please?

[Zubair_Muhammad · Accepted solution]

@armand453

Try this MEASURE

Please see attached file as well

Growth Measure =
VAR mymonth =
    SELECTEDVALUE ( 'Calendar'[Date].[MonthNo] ) - 1
VAR Jan_Same_year =
    CALCULATE (
        SUM ( Table1[Sales] ),
        DATEADD ( 'Calendar'[Date], - mymonth, MONTH )
    )
RETURN
    DIVIDE ( SUM ( Table1[Sales] ), Jan_Same_year ) - 1

[armand453]

Thank you your solution work