Need Help to Calculate Week on Week Growth Percentage using DAX

[deepak91g]

Year-Week	Profit	WoW%
2018-22	500	250%
2018-21	200	67%
2018-20	300	75%
2018-19	400	-

Expected output is WoW% 

I have index columns as well and for each year-week combination, I have unique records.

[Anonymous · Accepted solution]

@deepak91g

Please refer the below link. I think this should help you

https://community.powerbi.com/t5/Desktop/Week-over-Week-Comparison/td-p/298471

Regards

[Anonymous · Accepted solution]

@deepak91g

Please refer the below link. I think this should help you

https://community.powerbi.com/t5/Desktop/Week-over-Week-Comparison/td-p/298471

Regards

[deepak91g]

This worked.

But I have lots of Slicer/filters such as category, product name. Do you know, how can I make slicer to work with week-on-week measure?

Thanks for your help

[Anonymous · Accepted solution]

@deepak91g

Try using ALLSELECTED in place of ALL in your measure so that slicers work with your formula.

[deepak91g]

Fantastic, It worked.

I really appreciate your help in this. Learned new things while solving this problem.