Minus Moving Data to Previous Date

[Chanleakna123]

HI All , 

I have above data in Excel , and i wanna get moving minus data by data . For ex : Column 02/03/18( 19410)- Column 01/03/18(18310) = -1100 , you see some days are missing. but the data still minus the previous data. In addition , there would be -1100 as a result ,  Can i convert this -1100 to 1100 ? because i want to only extract the positive data to get in Total Number. 
What calculation should i use here  ?

thanks 

[v-qiuyu-msft]

Hi @Chanleakna123,

Assume the sample data below: 

You can create a measure: 

Measure = var LMDate= MAXX(FILTER(ALL('Table1'),'Table1'[Date]<MAX('Table1'[Date])),'Table1'[Date])
Return
IF(LOOKUPVALUE(Table1[Amount],Table1[Date],LMDate)=BLANK(),BLANK(),
ABS(MAX('Table1'[Amount])-LOOKUPVALUE(Table1[Amount],Table1[Date],LMDate)))

Best Regards,
Qiuyun Yu 

[Chanleakna123]

@v-qiuyu-msft , Hi dear , as i couldn't display the measure as per below . and the value i used only in the same table. 

[Chanleakna123]

hi @v-qiuyu-msft

i can use this calculation for only 1 type of materials . if i have 10 different materials , these aren't work . 

thanks with Regards, 

[v-qiuyu-msft]

Hi @Chanleakna123,

Please share your pbix file if possible. Please remove sensitive data before sharing. 

Best Regards,
Qiuyun Yu 

[Chanleakna123]

@v-qiuyu-msft

https://drive.google.com/open?id=1okd_xFYCT4TqGFBv6fTuq4k-0Uyb3u5I

please use the link for File fix. 

thank you so much for your assistance.