Previous Month

[Anonymous]

Looking for a way to calculate the previous month's value like below

The Previous Month Volume Column is what I am looking to do with DAX. So for Jan I want to See December, for Feb I want to see Jan. etc.

[aj1973]

Hi @Anonymous 

There are different ways to do it but I am going to refer to your sheet:

Load Previous Month  =

var _PreviousMonth= CALCULATE(MAX(Table[Month]), FILTER(ALL(Table), Table[Month] < MAX(Table[Month])))

return

CALCULATE(SUM(Table[Load Volume]) , FILTER(ALL(Table) ,Table[Month] = _PreviousMonth))

[Anonymous]

Hello for some reason I am not getting the previous value

[aj1973 · Accepted solution]

Hi @Anonymous 

Please add a column Order(for Month order) to your table and use

[ryan_mayu]

@Anonymous 

you need to have a date column

Previous = maxx(FILTER('Table','Table'[Date]=EDATE(EARLIER('Table'[Date]),-1)),'Table'[Load Volumn])