Comparing MTD this month with same period last Month

Question

Hi all,&nbsp;I am wanting to compare this MTD with the same period last month on a cumulative basis.&nbsp;For example:If today is 13/05/2021, I want the total value for the period 01/04/2021-13/04/2021.&nbsp;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.&nbsp;Below is my measure for the whole month:LastMonthAmount running total in Day = CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;[LastMonthAmount],&nbsp;&nbsp;&nbsp;&nbsp;FILTER(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALLSELECTED('Date'[Day]),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ISONORAFTER('Date'[Day], MAX('Date'[Day]), DESC)&nbsp;&nbsp;&nbsp;&nbsp;))&nbsp;&nbsp;Any help will be greatly appreciated.&nbsp;&nbsp;&nbsp;

v-lianl-msft · Accepted Answer

Hi JamesMartin&nbsp;,
&nbsp;
Please refer to similar threads, hope to help you.
https://community.powerbi.com/t5/Desktop/Dax-Same-period-last-months/m-p/837432&nbsp;
https://community.powerbi.com/t5/Desktop/Calculation-for-Last-month-Same-Period/m-p/730183&nbsp;
&nbsp;
Best Regards,Liang If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Comparing MTD this month with same period last Month

1 Reply

Related content

Compare data with previous period/last month

Using Measure to Compare Current Period to Previous Period

Sales Last month and Last month same period

Compare periods: same months in two different years

Display Current Month Range and Compare it with Previous Month Range