DAX. SUM of Value based on previous rows filtered by indicators

[Anonymous]

Hi,

I am unable to think of a DAX, that would add value from different row in same table based on date and identicator (Previous month needed)

I need to add value from previous month to the row for next month. 

I tried: 

= Calculate( SUM(Value), Filter( ALLEXCEPT(Table,Name), Date= Date previous month))

Date previous month is calculated with:

= PREVIOUSMONTH(Date)

The DAX needs to take only value from previous month. In data I have a large data size, so there are hundreds of names and several years of data.

This give me only blanks with no errors. 

[Anonymous · Accepted solution]

Found a solution:

= 

VAR Previous_Month = DATEADD(Date,-1,MONTH)

return Calculate( SUM(Value), Filter( ALLEXCEPT(Table,Name), Date= Previous_Month))

[amitchandak]

@Anonymous , if have date, then create a date table you can try like

Calculate( SUM(Value),PREVIOUSMONTH(Date[Date]) )

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA