Forum Discussion

willia93's avatar
willia93
Regular Visitor
5 years ago
Solved

Trying to match two dates from two different tables

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'...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    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.

willia93's avatar
willia93
Regular Visitor
5 years ago

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's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 years ago

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.