Forum Discussion

love's avatar
love
Icon for Helper I rankHelper I
8 years ago
Solved

How to return values based on if dates are within Slicer date range

Hello all :)   My user story: I would like to return values based on the following (in DAX)-->  If the "dates.start" (a date I get from a query called "Tasks") is earlier than the right date on m...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi love

     

    Calculated ccolumns do not react to slicer selections

     

    May be you could try a MEASURE instead

     

    MEASURE =
IF (
    AND (
        SELECTEDVALUE ( Tasks[dates.due] ) > MIN ( CalendarTable[Date] ),
        SELECTEDVALUE ( Tasks[dates.start] ) < MAX ( CalendarTable[Date] )
    ),
    0,
    1
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi love

 

Calculated ccolumns do not react to slicer selections

 

May be you could try a MEASURE instead

 

MEASURE =
IF (
    AND (
        SELECTEDVALUE ( Tasks[dates.due] ) > MIN ( CalendarTable[Date] ),
        SELECTEDVALUE ( Tasks[dates.start] ) < MAX ( CalendarTable[Date] )
    ),
    0,
    1
)
love's avatar
love
Icon for Helper I rankHelper I
8 years ago

Thank you very much Zubair_Muhammad, your solution worked perfectly. Also great info about the columns, thanks again!