Forum Discussion

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
8 years ago
Solved

Previous Month from NOW() or Today()

Thanks Advanced,   I have to get Previous month from NOW() or TODAY().   While using DATEADD or PREVIOUSMONTH it was asking Dates as columns. It won't allow this two functions.   Greg_Deckler 
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    How about:

     

    Measure = DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))

    ?

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Baskar,

The formula Greg_Deckler posted works correctly after test, please mark it as answer, more people will benefit from here. Today is 2018/1/16, you will expected result as follows.



Best Regards,
Angelia