Multiple Filters with OR

[ReadTheIron]

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 has an upcoming date in one group and a past date in another, I want to display the asset, but I don't want to display the past date.

After some googling, I tried creating tables for the unique values in each column and then writing a measure that assigned a 1 or a 0 based on whether the selected value appeared in any of the columns of the original table, but this didn't work. (And I didn't even get into how to write a relative date in DAX, though I could probably find info on that easily enough if I could get my other conditions working)

Still quite new to this; any help appreciated!

[jdbuchanan71 · Accepted solution]

@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]

That worked beautifully! Thank you so much - this will be very helpful.