the calculation for Prev MTD is like this
Last MTD = CALCULATE(sum(DAILYTRANSACTIONS[Amount]), DATEADD(DATESMTD(YEAR_MONTH_DIMENSION_TAB[Date]), -1, MONTH))
The value is showing if only I selected month filter as Feb 2017.
And for this
Prev MTD = CALCULATE(DAILYTRANSACTIONS[Amount MTD], SAMEPERIODLASTYEAR(YEAR_MONTH_DIMENSION_TAB[Date]))
It shows Dec 2016 value instead of Jan 2017.
Any help would be appreciated.
Go to Solution.
You can refer to below formula to calculate the running total and the previous running total.
RunningTotal = CALCULATE(SUM('Table'[Amount]),FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))
View solution in original post
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!