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
Solved! Go to 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")
@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")
User | Count |
---|---|
141 | |
84 | |
62 | |
61 | |
55 |
User | Count |
---|---|
211 | |
108 | |
88 | |
75 | |
72 |