trying to add 1 day to DAX variable date

[Anonymous]

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)

[tackytechtom · Accepted solution]

Hi @Anonymous ,

Have you tried it with a simple +1?

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

Let me know 🙂

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

[Anonymous]

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

It worked!!!