Forum Discussion
DAX for Week Over Week comparison between two years
Hi Everyone. I have a task where I need to calculate week over week lease renewal comparions between two years and broken down by Regions. In my Renewal Report table I have a column named "Signed ...
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
| FY23 | ||||||
| Regions | Total Count | Signed YTD | % Signed | Last Week | % Signed Last Week | Change from Last Week |
| Central | 729 | 321 | 44% | 264 | 36% | 8% |
| West | 622 | 205 | 33% | 153 | 25% | 8% |
| East | 644 | 258 | 40% | 180 | 28% | 12% |
| BA | 185 | 51 | 28% | 38 | 21% | 7% |
| TOTAL | 2180 | 835 | 38% | 635 | 29% | 9% |
| FY24 | ||||||
| Regions | Total Count | Signed YTD | % Signed | Last Week | % Signed Last Week | Change from Last Week |
| Central | 617 | 284 | 46% | 236 | 38% | 8% |
| West | 530 | 254 | 48% | 203 | 38% | 10% |
| East | 591 | 276 | 47% | 245 | 41% | 5% |
| BA | 137 | 63 | 46% | 44 | 32% | 14% |
| TOTAL | 1875 | 877 | 47% | 728 | 39% | 8% |