Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
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()))

    ?

anmattos's avatar
anmattos
Icon for Advocate I rankAdvocate I
5 years ago

Anonymous,

 

I had the same problem today. I just used the function EDATE, like that:

 

EDATE(<start_date>, <months>)

 

EDATE ( TODAY(), -1)

 

It handles special cases like the previous month not having the 31st that, for example.

  • Mrtnkbg's avatar
    Mrtnkbg
    Icon for Advocate I rankAdvocate I
    2 years ago

    This solved my issue.

     

    I was looking for a solution to creating a measure for a text title that should contain the name of last/previous month from the current date via concatenate.