Forum Discussion
maurcoll
Helper IV
Helper IVGreater than Date Selected
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
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 _ResultIf it answers your query, please mark my rely as the solution
1 Reply
- Alex87
Solution Sage
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 _ResultIf it answers your query, please mark my rely as the solution