Trying to match two dates from two different tables

[willia93]

Looking at two different tables that are linked by a unique ID, need to see matches and non matches for table A based on table B which has what date should be. 

Tried using a matrix but it doesn't show the corresponding date that is associated with the ID on table A and B it just is showing the earliest date.

Any other tools I can use? Merging queries isn't working since I have to essentially calculate the date because it is in 3 seperate columns for year/month/day.

[amitchandak]

@willia93 , Try a measure like

minx(values(TableA[ID]) , Min(Min(TableA[Date]) , Min(TableA[Date])))

with Id from Table A

[willia93]

@amitchandak Ok thank you! However how do I see if whether or not it matches from Table B? I am trying to use a matrix but I cannot figure out where to put the values/measure within it. Is there a better visualization to use?

[V-lianl-msft · Accepted solution]

Hi @willia93 ,

As far as I understand, it can't match. For example, if there are 3 dates for an ID in table a and 8 dates for the same ID in table B, This cannot be matched.

If I misunderstand your intention, please provide some sample data and the results you expect.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.