Week over Week % Change

[Anonymous]

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

[KatBous]

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!

[Anonymous · Accepted solution]

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:

RETURN

IF (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".