Forum Discussion

arvindyadav's avatar
arvindyadav
Icon for Post Partisan rankPost Partisan
7 years ago
Solved

How to find Pre Month MTD

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...
Need Help
  • arvindyadav's avatar
    arvindyadav
    7 years ago

    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.

vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
7 years ago

arvindyadav 

 

Hi,

 

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

 

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

 

 

 

Thanks,

Vivek

arvindyadav's avatar
arvindyadav
Icon for Post Partisan rankPost Partisan
7 years ago

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.