Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

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,
1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
Fowmy
Super User
Super User

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

amitchandak
Super User
Super User

@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

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.