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'[D...
  • 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

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?

    • gmsamborn's avatar
      gmsamborn
      Super User
      9 months ago

      Hi mattAtBradyCorp 

       

      Try this:

      = MONTH( my_date_var - 7 )

       

      Let me know if you have any questions.