Item lists A&B have common entries and I created a relationship between them.
I need to identify the common entries where date A comes is a later date to B
I thought this would be a straight forward one with following Dax, but the calculated result is only "no issue". I checked, there are definitely cases where date A are greater than date B while others are smaller. The calculation should find both issue & no issue
file on wetransfer link
date comparison = IF('A schedule'[date A].[Date] > 'A schedule'[date A].[Date],"issue","no issue")