Greater than Date Selected

[maurcoll]

Hi I need help to identify the people who's training has not expired based on a date selected. So for example if i select a date from a slicer the the table will only show me the people whose training is still valid after this date. So for example with the below table if i selected 01/02/2025 only employees 1 and 4 would show in the table. Employee Training Expires Employee 1 First Aid 01/05/2025 Employee 2 First Aid 01/04/2024 Employee 3 Fire Marshall 27/10/2024 Employee 4 Supervisor 30/03/2025

[Alex87 · Accepted solution]

Hello,

I recreated your use case. This measure will work for you as long as you DO NOT have an active relationship between your date dimension table and your fact table.

IsTrainingValid = 
VAR _SelectedDate = MAX('Date Table'[Date])
VAR _Result = 
IF(
   MAX(YourTable[Expires]) > _SelectedDate, 
   "Valid", 
   "Expired")

RETURN
_Result

If it answers your query, please mark my rely as the solution