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 value for the date. So when I try to filter DateTable <= maxdate it doesent filter.

If I define the Variable like Date(2021-09-01) everything works fine.

3 Replies

  • 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

  • Stabben23's avatar
    Stabben23
    Helper I
    4 years ago

    I think I have to pologize, I work in Power Pivot, normally Power BI. And I now realize that these measure doesent act the same. All answers is probably correct. But in Power Pivot it fails when I put -7 in the formula.

    If I skip -7 it shows me a results, but I can not find a way to offset my enddate.