Forum Discussion
Week over Week % Change
I'm tracking how many emails we send out every week. I want to display the change WoW as a percentage. I have tried to use the measure from the post here: Week over Week Change. But it only return...
Hi,
I created a table with similar data and copied the measure from your post, it works fine.
If you specify how your data is different from the table I created maybe we can find the issue
**I did change the 'Return' part to:RETURNIF (lastWeekAmount=0,"N/A",DIVIDE ( SUM( 'Email data'[Emails sent] ) - lastWeekAmount, lastWeekAmount, 0 ))so that weeks that come after a week with no sales, return "N/A".
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:
Measure =
VAR LastWeekCVs =
CALCULATE (
SUM ( FW_Appended[CVs weekly change] ),
FILTER (
ALL ( 'CALENDAR' ),
'CALENDAR'[week]
= MIN ('CALENDAR'[week] ) -1))
RETURN
IF (LastWeekCVs=0,"N/A",
DIVIDE ( sum (FW_Appended[CVs weekly change]) - LastWeekCVs,LastWeekCVs, 0))
And this my date table, which I named Calendar.
Many thanks!