Year-WeekProfitWoW%2018-22500250%2018-2120067%2018-2030075%2018-19400- Expected output is WoW% I have index columns as well and for each year-week combination, I have unique records.

deepak91gPlease refer the below link. I think this should help youhttps://community.powerbi.com/t5/Desktop/Week-over-Week-Comparison/td-p/298471 Regards

Forum Discussion

deepak91g

Resolver II

8 years ago

Solved

Need Help to Calculate Week on Week Growth Percentage using DAX

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.

Need Help

Anonymous
8 years ago
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
8 years ago
deepak91g
Try using ALLSELECTED in place of ALL in your measure so that slicers work with your formula.

4 Replies

Anonymous
Not applicable
8 years ago
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
  Resolver II
  8 years ago
  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
    Not applicable
    8 years ago
    deepak91g
    Try using ALLSELECTED in place of ALL in your measure so that slicers work with your formula.

Forum Discussion

Need Help to Calculate Week on Week Growth Percentage using DAX

4 Replies

Related content

Percentage Achievement and Percentage Growth calculation

Calculate growth based on calculation group item

Calculating annual percentage growth

Calculate Percentage

Investment growth