Check if Dates are same, but only when another column value exists in another column.

[gwoodley]

Hi, I'm a little stuck here, I'm trying to compare a date column to see if the dates are the same, but only if a value in a one column first exists in another column.

All columns are on the same table.

Example

Step 1 - I want to see if the value in Parent Order# column exists in Order# column.

Step 2 - If it does I want to see if the Dates are the same.

Step 3 - Add a new column called match with Yes or No.

Order#	Parent Order#	Date	Match
A12345		02/07/2025	No
A12346	A12345	02/07/2025	Yes
A12347	B12346	02/01/2025	Yes
A12348		02/04/2025	No
B12345	A12345	02/08/2025	No
B12346		02/01/2025	No
B12347		02/04/2025	No
B12348	A12345	02/04/2025	No
c12345		02/04/2025	No
c12346		02/04/2025	No
c12347	B12346	02/01/2025	Yes
c12348		02/04/2025	No

[DataInsights · Accepted solution]

@gwoodley,

Try this calculated column:

Match = 
VAR vParentOrder = 'Table'[Parent Order#]
VAR vDate = 'Table'[Date]
VAR vTable =
    FILTER (
        'Table',
        'Table'[Order#] = vParentOrder
            && 'Table'[Date] = vDate
    )
VAR vResult =
    IF ( ISEMPTY ( vTable ), "No", "Yes" )
RETURN
    vResult

[gwoodley]

Thank you 👍