How to find Pre Month MTD

[arvindyadav]

Hi Team,

I am using this formula 

PRE MTD = TOTALMTD(sum(Table1[Profit],DATEADD(DimDate[Date],-1,MONTH)) for getting Previous month to date value but not getting expected value.

Please help me what is wrong in this formula.

[vivran22]

@arvindyadav 

Hi,

You may use the formula PREVIOUSMONTH(DimDate[Date]) instead. 

On a different note, you should close the Sum bracket. 

Thanks,

Vivek

[arvindyadav · Accepted solution]

Hi @vivran22 ,

Thanks for your advice I made mistake on the relationship between two tables that's why I was unable to get an answer. After mapping the data it works for me.

Thanks,

Arvind.