Forum Discussion
Percent change YoY for a given week
Thank you in advance to anyone that is willing to help.
I am looking to find the percent growth or decline YoY for a given week. The three columns that have the relevant information are Fiscal Week ID, Volume TY and Volume LY. The Fiscal Week IDs are listed as 202001, 202002... I am looking to do this for Fiscal week 202006.
I have been searching Google and videos however have not found a formula that works. I appreciate the assistance and the learning experience here.
hi, Maroonvogel
You may refer to this blog:
https://www.sqlbi.com/articles/custom-year-over-year-calculation-in-dax/
If you still have problem, Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Best Regards,
Lin
1 Reply
v-lili6-msftCommunity Support
hi, Maroonvogel
You may refer to this blog:
https://www.sqlbi.com/articles/custom-year-over-year-calculation-in-dax/
If you still have problem, Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Best Regards,
Lin