Change since last last report date

[jksl_12]

Hey there

I have run into a problem with the automated report that I am setting up and I am hoping that someone will be able to point me in the right direction. It is the last thing I am missing, and I would really enjoy if it was possible to include it.

Below I have an example of my data that is put into the table.

Region	Date of report	Category	Storage amount
North	December 1st	Pencils	4.500
South	December 1st	Pencils	6.000
West	December 1st	Pencils	7.500
Central	December 1st	Pencils	10.500
North	November 1st	Pencils	5.000
South	November 1st	Pencils	5.000
West	November 1st	Pencils	8.000
Central	November 1st	Pencils	12.000

I would love to be able to set up a formular so that I can see the difference from last month. However the thing that I would enjoy even more is for this to happen automatically when I refresh my data. On January 1st I am going to be getting new data put into the same tabel, so then I would want it to be compared to the December data instead and see the difference there between the values.

So basically what I would want is for it to look like this and then be able to update it without having to do that manually. 

Region	Storage amount	Change since last
North	4.500	-500
South	6.000	1.000
West	7.500	-500
Central	10.500	-1.500

I hope someone will be able to help me out, and if there is anything else you need in order to be able to solve my problem, then do let me know!

Thanks in advance and kind regards

- J

[ryan_mayu · Accepted solution]

@jksl_12 

pls make sure the date of report column is in date type

then you can create two measures

Measure = 
VAR _date=max('Table'[Date of report])
return CALCULATE(sum('Table'[Storage amount]),ALLEXCEPT('Table','Table'[Region]),'Table'[Date of report]=_date)

Measure 2 = 
VAR _date=EDATE(max('Table'[Date of report]),-1)
return [Measure]-CALCULATE(sum('Table'[Storage amount]),ALLEXCEPT('Table','Table'[Region]),'Table'[Date of report]=_date)

pls see the attachment below