Show sum previous month and specific month

[mapr]

Hi everybody, I have been missing for a some time.

I need a card that shows the units of the previous month or a specific month, the date field may contain duplicate records from what I understand I cannot use DATEADD unless I use an auxiliary table with dates in model. I have tried the latter but it does not work.

Any ideas? Thank you very much.

With this table the measure works, there are duplicates dates:

Also, I don't understand what I am doing wrong because this measurement works in one table but not in another:
Measure = CALCULATE(SUM('Table'[uds]),DATEADD('Table'[Date],-1,MONTH))

Shouldn't it indicate in both tables that there are duplicate dates?

This is the error:

[mapr · Accepted solution]

Ok, DATEADD is not ok, I need to use another formula to calculate this.

Finally, I have solved with this formula:

Penalizacion_Mes_Previo_VF = VAR _year = IF(MONTH(NOW())=1,YEAR(NOW())-1,YEAR(NOW()))

Return

CALCULATE(SUM(table[Uds]),AND(MONTH(table[date])=MONTH(NOW())-1,YEAR(table[date])= _year))