Forum Discussion

Dodo96's avatar
Dodo96
Regular Visitor
1 year ago
Solved

Dynamic date difference

Hello,   I'm encountering some difficulties in calculating a dynamic date difference between a date in Table1 and the maximum date selected from a slicer. The slicer uses the Calendar table, which ...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

    Hello Dodo96 

    DAX for calculated column

     

    Date Range Category =

    VAR SelectedMaxDate =

        CALCULATE (

            MAX ( 'Calendar'[Date] ),

            ALLSELECTED ( 'Calendar' )

        )

    VAR DaysDiff =

        DATEDIFF ( Table1[Date], SelectedMaxDate, DAY )

    RETURN

        SWITCH (

            TRUE(),

            DaysDiff <= 30, "Within 30 days",

            DaysDiff <= 60, "31 to 60 days",

            DaysDiff > 60, "Over 60 days",

            BLANK()

        )

    Thanks,
     Pankaj Namekar | LinkedIn

    If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Dodo96 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Thanks