Growth % by Week with DAX

[BirhanAYDS]

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 !

[Anonymous]

Hi @BirhanAYDS ,

You can refer the content in the following links to achieve it:

Current week vs last week sum

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

[amitchandak]

@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-La...

or video - https://youtu.be/pnAesWxYgJ8