Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Show data if end date is not reached

Hi guys,   I want to see which employees were working in my company during a filtered time period. I tried using these measures:     SelectedDate = 'Date'[Date]     Active = IF(SelectedDate > MI...
Need Help
  • rainer1's avatar
    rainer1
    6 years ago

    Hi Anonymous,

     

    you can create a measure, replace Dates[Date] with your slicer Dates Table.

    Active = 
SWITCH(
    TRUE();
    Max('Table'[EndDate]) = BLANK(); "Y";
    MAX(Dates[Date]) < MAX( 'Table'[EndDate]); "Y"; "N"
    )

     -------------------------------------------------------------------
    Did I answer your question? Mark my post as a solution!
    It was useful? Press Thumbs Up!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi rainer1 ,

 

This works perfectly if I have one specific date, but I would like to be able to see this information for dates a user can pick.

Do you know how to solve this issue?

 

Kind regards

rainer1's avatar
rainer1
Icon for Resolver III rankResolver III
6 years ago

Hi Anonymous,

 

you can create a measure, replace Dates[Date] with your slicer Dates Table.

Active = 
SWITCH(
    TRUE();
    Max('Table'[EndDate]) = BLANK(); "Y";
    MAX(Dates[Date]) < MAX( 'Table'[EndDate]); "Y"; "N"
    )

 -------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!