help appreciated
1 Topic
Comparing MTD this month with same period last Month
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.Solved3.4KViews0likes1Comment