Forum Discussion
Solved
Multiple Filters with OR
My data looks something like this: I want to create a visual showing all upcoming inspections that would look something like this: I want to display only the upcoming dates. If an asset...
ReadTheIron I think the easiest way to do it would be to have a measure that checks each group inspection column and returns the date it is > TODAY().
A Inspection = VAR _Inspection = SELECTEDVALUE ('Table'[A Group Inspection] ) RETURN IF ( _Inspection > TODAY(), _Inspection )B Inspection = VAR _Inspection = SELECTEDVALUE ('Table'[B Group Inspection] ) RETURN IF ( _Inspection > TODAY(), _Inspection )C Inspection = VAR _Inspection = SELECTEDVALUE ('Table'[C Group Inspection] ) RETURN IF ( _Inspection > TODAY(), _Inspection )
ReadTheIron I think the easiest way to do it would be to have a measure that checks each group inspection column and returns the date it is > TODAY().
A Inspection =
VAR _Inspection = SELECTEDVALUE ('Table'[A Group Inspection] )
RETURN
IF ( _Inspection > TODAY(), _Inspection )B Inspection =
VAR _Inspection = SELECTEDVALUE ('Table'[B Group Inspection] )
RETURN
IF ( _Inspection > TODAY(), _Inspection )C Inspection =
VAR _Inspection = SELECTEDVALUE ('Table'[C Group Inspection] )
RETURN
IF ( _Inspection > TODAY(), _Inspection )
That worked beautifully! Thank you so much - this will be very helpful.
