topic Re: DateADD for single value in DAX Commands and Tips

DateADD for single value

Anonymous — Tue, 28 Jul 2020 14:33:30 GMT

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,

Re: DateADD for single value

amitchandak — Tue, 28 Jul 2020 15:22:30 GMT

Anonymous ,

Try like

VAR SelectedDateCurrent = SELECTEDVALUE('Date'[Date])
Return DATE(year(SelectedDateCurrent),Month(SelectedDateCurrent)-1,day(SelectedDateCurrent))

refer

https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power-BI-Turning/ba-p/1187827

another option

VAR SelectedDateCurrent = maxx('Date' , dateadd('Date'[Date],-1, month))
Return SelectedDateCurrent

dateadd need continuous dates

Re: DateADD for single value

Fowmy — Tue, 28 Jul 2020 15:24:14 GMT

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

Re: DateADD for single value

mattAtBradyCorp — Wed, 05 Nov 2025 21:22:27 GMT

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?

Re: DateADD for single value

gmsamborn — Thu, 06 Nov 2025 01:43:40 GMT

Hi mattAtBradyCorp

Try this:

= MONTH( my_date_var - 7 )

Let me know if you have any questions.