Forum Discussion
DAX for Week Over Week comparison between two years
The columns in this table is what should be used to build the report. Basically in the first week of February 2023 (FY) we had 3 renewals signed vs the first week of February 2024 (FY) we have 4 renewals signed. I need to show week over week comparison between the two fiscal years. This data should be shown as a percentage and also I want to show the week over week percentage change between them.
| Fiscal Year | Renewals Signed Date | Regions (Central, West, East) |
| 2023 | 02/05/23 | Central |
| 2023 | 02/03/23 | Central |
| 2023 | 02/02/23 | Central |
| 2024 | 02/02/24 | Central |
| 2024 | 02/02/24 | Central |
| 2024 | 02/02/24 | Central |
| 2024 | 02/02/24 | Central |
This is the outcome i need to show for all regions for week over week (2023 vs 2024)
please explain how you get the expected outcome from the sample data you posted.
I need to get a total count of signed renewals for FY23 and FY24 and then break it down by Region and then extract the Date from the Renewals Signed Date column. I then have to Divide the Renewals Signed for the week by the Total Count of Renewals Signed. I hope the data below clarifies your question:
FYI, "Advisors" is a region
second request: Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
