Monthly / weekly Percentage change

[Mike_Mace]

Hi all,

I have a table of metrics, some shown on attached snip. There are frequent new entries on table, usually weekly, can vary. Current table is an appended/grouped table so there will be more than 1 of same Date in rows. (I say this as I read about unpivoting columns which did not work for this exercise)

I need to show the percentage change at end of month overalls

On a second stage the percentage change between the last two entries (whenever those are) will be needed too

Percentage change formula as simple as it may be (X2 - X1)/X1 I don't seem to find the right DAX code to make this happen. 

(My thinking still partly works on excel's cells function and always hit a deadend)

Thanks in advance all. Appreciate this forum!

metrics

[Mike_Mace · Accepted solution]

I had to change the integrals to days *28 to reach a month because data entry is per week

% change =

VAR __PREV_MONTH =

    CALCULATE(

        SUM('table'[column]),

        DATEADD('table'[Date], -28, DAY)

    )

RETURN

    DIVIDE(

        SUM('table'[column]) - __PREV_MONTH,

        __PREV_MONTH

    )