Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DateADD for single value

Hi everyone,

 

I am looking for a way to use DateADD (or previousmonth) to have the previous month of the date that I am selecting.

 

Example : 

VAR SelectedDateCurrent = SELECTEDVALUE('Date'[Date])
Return DATEADD(SelectedDateCurrent,-1,MONTH)
 
Of course this code doesn't work because DateADD can only have a column as a parameter, but you have now the idea.
I am using an IF to fix it for now (if = 1 then 12) but I am looking for an easiest way.
 
Thank you !
Loveboch,
  • Fowmy's avatar
    Fowmy
    6 years ago

    Anonymous 

    Try 

    =EDATE([DATE],-1)

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn

4 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    6 years ago

    Anonymous 

    Try 

    =EDATE([DATE],-1)

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon on the right if you like this reply 🙂

    YouTube, LinkedIn

    • mattAtBradyCorp's avatar
      mattAtBradyCorp
      Frequent Visitor
      9 months ago

      This answers the original question, but I came here looking for a way to figure out the month from seven days ago. So I want something like =MONTH( EDATE(my_date_var, -7, DAY) )

      But as far as I can tell this isn't possible?