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 returns the nonsense you see in the screenshot.
There will be weeks when we did not send any emails. Between weeks 4-6 for example. Not sure if this will affect the measure in any way.
Measure =
VAR lastWeekAmount =
CALCULATE (
SUM ( 'Email Data'[Emails sent] ),
FILTER (
ALL ( 'Email Data' ),
'Email data'[Week]
= MIN ( 'Email Data'[Week] ) - 1
)
)
RETURN
DIVIDE ( SUM( 'Email data'[Emails sent] ) - lastWeekAmount, lastWeekAmount, 0 )
Thank you
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".
2 Replies
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))RETURNIF (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!
