Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Damini Gohil]

Hello Guys, 

I have a KPI data, which is as below. I want to find WoW%, YoY% and MoM% values. Please help me. I tried some DAX but, it does not work.

Thank You !

——————————
Damini Gohil
BI Developer
——————————

[George Johnson]

Hi Domini,

You can try inserting your data names into the formulas below.

YoY = (DIVIDE(SUM(Sales[SalesAmount]),CALCULATE(SUM(Sales[SalesAmount]),PREVIOUSYEAR(‘Calendar'[Date])))-1)

CALCULATE( [Total Sales] , DATESMTD( Dates[Date] ) )

SALES SPLY = CALCULATE([Total SALES],SAMEPERIODLASTYEAR(‘Date'[Date]))
YoY SALES Var = [Total SALES]-[SALES SPLY]

Total Sales = TOTALYTD(SUM([Sales]),’Date'[Date])
Total Sales LY = CALCULATE([Total Sales],SAMEPERIODLASTYEAR(DATESYTD(‘Date'[Date])))

——————————
George Johnson
BI Developer
Jacksonville FL
——————————
——————————————-

[Vishesh Jain]

Hi ,

For MoM and YoY, there are quick measures available. Just right click on the table and click on ‘quick measures’.

For WoW there is nothing readily available and you will have ?to create the week details in your calendar table and create a measure from it.

Hope this helps.

Thank you,

——————————
Vishesh Jain
Owner
VR Construction
——————————
——————————————-

[William Skelley]

Hello Damini:

To possibly add a bit to the other great responses, please see attached.

Thank you,

Bill

——————————
William Skelley
01106
Longmeadow MA
8602807221
——————————
——————————————-

[Lutz Bendlin]

Please be aware of the pitfalls of using these YoY, MoM etc measures with “open”  periods. Meaning for example what happens when you compare a current (incomplete) month with a prior month. In that case you need to do a MoMTD calculation that only considers the same date range in both the months you are comparing. So if you are comparing the current month to the last month and the current day of month is 3 then you should only compare to the first three days of the prior month etc.

(This gets weird fast as the weekday patterns in these months is most likely different , so you slide into the apples/oranges territory very rapidly.)

——————————
Lutz
——————————
——————————————-