Date greater than other date issue

[Mike_Mace]

Hi Forum,

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")

https://we.tl/t-gcQ64i4381

[amitchandak · Accepted solution]

@Mike_Mace , Create a new column in A schedule like

if('A schedule'[date A] < minx(filter('B schedule', 'A schedule'[Item List A] = 'B schedule'[Item List B] ),'B schedule'[date B]) ,"Yes", "No")