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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

willia93 , Try a measure like

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

 

with Id from Table A

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.