Forum Discussion
Change from previous month
Hi,
I need to find the change from previous month - I was able to do a Quick Measure to get % MoM change, but not sure how to do a simple $ or point change.
My report pulls from a folder of weekly reports, but this is a filter table just showing the last report from each month...
| Total | Unapplied | >30 | Percent > 30 | Report Date |
| $162,440.22 | $64,38.01 | $167,386.87 | 11.67% | 1/26/2018 0:00 |
| $164,566.38 | $34,974.99 | $151,637.17 | 14.89% | 2/23/2018 0:00 |
| $166,201.05 | $63,247.38 | $146,188.77 | 11.71% | 3/30/2018 0:00 |
2 Replies
You can use
Last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date Filer],-1,MONTH))) MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date Filer]))In this case, the date should be marked as a date table in the model view. subtract and get change
Anonymous ,
Please share some sample data and give the expected result.
Regards,
Jimmy Tao
