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 me what is wrong in this formula.

 

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.

2 Replies

  • 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.