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 Anonymous ,

 

First you need to create a CALENDAR table and use date field as silcer.

CALENDAR = CALENDARAUTO()

Please refer to the measure below.

active = 
var startdate = SELECTEDVALUE('Table'[StartDate])
var enddate = SELECTEDVALUE('Table'[EndDate])
var mindate = MIN('CALENDAR'[Date])
var maxdate = MAX('CALENDAR'[Date])
return
IF((enddate<>BLANK()&&enddate<mindate)||startdate>maxdate,"n","y")

Result would be shown as below.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.