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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DrakoLuke
Regular Visitor

trying to add 1 day to DAX variable date

Hi,

 

   I have this ia a DAX but I have not been able to add 1 day...as it is a variabele...tried several fucnitonas as format but still doesn work... this was my last try and still doesn't work. Any ideas how to add 1 day?

 

var varEndDate = DATEADD(DATEVALUE(MAX('BI Data Full'[Iteration End Date])),1,DAY)
1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

Hi @DrakoLuke ,

 

Have you tried it with a simple +1?

tackytechtom_0-1680935121255.png

 

DatePlusOneMeasure = 
VAR _datePlusOne =  MAX ( DateTable[Date] ) + 1
RETURN
_datePlusOne

 

Let me know 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

View solution in original post

2 REPLIES 2
tackytechtom
Super User
Super User

Hi @DrakoLuke ,

 

Have you tried it with a simple +1?

tackytechtom_0-1680935121255.png

 

DatePlusOneMeasure = 
VAR _datePlusOne =  MAX ( DateTable[Date] ) + 1
RETURN
_datePlusOne

 

Let me know 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

I feel so...@#@#....Spent hours and did ocure to me!!!!

 

It worked!!!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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