Comparing MTD this month with same period last Month

JamesMartin — Thu, 13 May 2021 11:00:20 GMT

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.

Re: Comparing MTD this month with same period last Month

V-lianl-msft — Mon, 17 May 2021 06:18:18 GMT

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.

topic Re: Comparing MTD this month with same period last Month in Developer

Comparing MTD this month with same period last Month

Re: Comparing MTD this month with same period last Month