Comparing MTD this month with same period last Month

[JamesMartin]

Hi all,

I am wanting to compare this MTD with the same period last month on a cumulative basis.

For example:

If today is 13/05/2021, I want the total value for the period 01/04/2021-13/04/2021.

I am able to get the running total for the whole previous month but I would like to know how I can get just up until the 13th and then tomorrow for up until the 14th etc.

Below is my measure for the whole month:

LastMonthAmount running total in Day =

CALCULATE(

    [LastMonthAmount],

    FILTER(

        ALLSELECTED('Date'[Day]),

        ISONORAFTER('Date'[Day], MAX('Date'[Day]), DESC)

    )

)

Any help will be greatly appreciated.

[V-lianl-msft · Accepted solution]

Hi @JamesMartin ,

Please refer to similar threads, hope to help you.

https://community.powerbi.com/t5/Desktop/Dax-Same-period-last-months/m-p/837432 

https://community.powerbi.com/t5/Desktop/Calculation-for-Last-month-Same-Period/m-p/730183 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.