Forum Discussion

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

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?