week % change

[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!

[v-luwang-msft]

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

[KatBous]

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!