Check if two dates match

[Julie_]

Hello guys,

I need to write a measure to check if two Dates match.

the two tables are connected between the serial number.

I already tried:
IF(table1[ChequeDate] = RELATED(table2[InstallationDate]),0,1)

Please help!

[Martin_D · Accepted solution]

Matching Date Test =
IF (
    SELECTEDVALUE ( table1[ChequeDate] ) = SELECTEDVALUE ( table2[InstallationDate] )
    // prevent returning 0 if blank = blank because multiple dates were included in the context:
    && HASONEVALUE ( table1[ChequeDate] ) && HASONEVALUE ( table2[InstallationDate] )
    0,
    1
)