Forum Discussion
week % change
Hi to everyone,
I tried to use this solution in my data but I have two issues.
1) I cannot get the LastWeekSum result to be presented at week level. Instead it repeats itself for eveyday of the week.
2) although last week sum is correct, the weekly % change is not.
These are my data.
| Date | Branch | CVs | CVs weekly change |
| 30/09/2022 | a | 5 | 5 |
| 30/09/2022 | b | 7 | 7 |
| 30/09/2022 | c | 3 | 3 |
| 30/09/2022 | d | 10 | 10 |
| 30/09/2022 | e | 0 | |
| 14/10/2022 | a | 17 | 12 |
| 14/10/2022 | b | 22 | 15 |
| 14/10/2022 | c | 9 | 6 |
| 14/10/2022 | d | 20 | 10 |
| 14/10/2022 | e | 1 | 1 |
| 28/10/2022 | a | 35 | 18 |
| 28/10/2022 | b | 33 | 11 |
| 28/10/2022 | c | 14 | 5 |
| 28/10/2022 | d | 30 | 10 |
| 28/10/2022 | e | 3 | 2 |
This is the formula:
Many thanks!
2 Replies
HI KatBous ,
Not clear for your first picture ,pls check if the below pbix file is your need. If not ,pls show what your epxected result.And according your data and dax ,it could work ,check the relationship between your table and date type.
Best Regards
Lucien
Thank you for pointing that out! I created new Date Tables as suggested here Solved: Re: Average total calculated by weekly date - Microsoft Power BI Community
And problem solved!
