Forum Discussion

Stabben23's avatar
Stabben23
Helper I
4 years ago

Date Variable wrong format

Hi,   I want to create a variable in my DAX formula. Var = maxdate= max(DateTable[Date])-7, this should gives me the maxdate from selected slicer in YYYY-MM-DD format but it gives me a numeric val...
Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

HI Stabben23 ,

 

You can try below code:-

Measure =
VAR selected_date =
    SELECTEDVALUE ( table[date] )
VAR maxx_date =
    DATEVALUE ( FORMAT ( selected_date - 7, "YYYY-MM-DD" ) )
RETURN
    maxx_date

Thanks,

Samarth