cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
deepak91g Regular Visitor
Regular Visitor

Need Help to Calculate Week on Week Growth Percentage using DAX

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
vmakhija Member
Member

Re: Need Help to Calculate Week on Week Growth Percentage using DAX

@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

vmakhija Member
Member

Re: Need Help to Calculate Week on Week Growth Percentage using DAX

@deepak91g

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

4 REPLIES 4
Highlighted
vmakhija Member
Member

Re: Need Help to Calculate Week on Week Growth Percentage using DAX

@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 Regular Visitor
Regular Visitor

Re: Need Help to Calculate Week on Week Growth Percentage using DAX

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

vmakhija Member
Member

Re: Need Help to Calculate Week on Week Growth Percentage using DAX

@deepak91g

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

deepak91g Regular Visitor
Regular Visitor

Re: Need Help to Calculate Week on Week Growth Percentage using DAX

Fantastic, It worked.

 

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