Forum Discussion
Growth % by Week with DAX
Hi all, I want to ask a question. I need to calculate growth rate by weeks. If I selected one week dax have to be calculate last week. If I choose 2, growth rate have to calculated by these selected weeks. Here is the problem. I look at the examples I see these growth rates calculated for just same year or same month. But in this scenario, it would be 2020/12 ( December) and 2021/1 (january). So if I selected January / 2020 - week no 1, I should see December / 2020 52. week.
I hope I could explain my situation.
Thank for attention !
2 Replies
- amitchandak
Super User
BirhanAYDS , refer to my blog, how to handle week vs week
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123or video - https://youtu.be/pnAesWxYgJ8
- AnonymousNot applicable
Hi BirhanAYDS ,
You can refer the content in the following links to achieve it:
Measure displaying last week sum
Calculating Weekly Sales w/DAX In Power BI
If the above ones are not applicable for your scenario, please provide some sample data in your model (exclude sensitive data) and expected result with functionalities. Thank you.
Best Regards