Change from previous month

[Anonymous]

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

[v-yuta-msft]

@Anonymous ,

Please share some sample data and give the expected result.

Regards,

Jimmy Tao

[amitchandak]

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