Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Match Data in Power BI Desktop

Hello Guys,    I am new using power bi, and need to relate two tables that share a common column ("Clients"), it means, data with the same information My problem is that in one column I have 10 di...
General Comment
Interesting Links
Need Help
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Please show your datasets and your expected result.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

 

HIi, 

 

Dataset 1

ClientIVR_1FVR_1
1000018:30:0011:00:00
1000038:00:0017:00:00
1000057:00:0012:00:00
1000066:00:0017:00:00
1000088:00:0017:00:00
1000098:30:0017:00:00
1000128:00:0016:00:00
1000128:00:0012:00:00
1000137:00:0013:00:00
1000148:00:0016:00:00
1000158:00:0012:00:00
1000167:00:0012:00:00
1000187:00:0012:00:00
1000197:00:0017:00:00
1000237:00:0013:00:00
1000257:00:0013:00:00
1000278:00:0017:00:00
1000297:00:0012:00:00
1000318:00:0012:00:00

 

Dataset 2  

ClientDelivery hour
11761216:51:29
11761217:51:29
11761218:51:29
11640319:51:29
11640320:51:29
11640321:51:29
11640322:51:29
11640323:51:29
1164030:51:29
1164031:51:29
1164032:51:29

 

Expeceted Result

ClientDelivery hourIVR_1FVR_1
11761216:51:298:30:0011:00:00

 

I want to join both tables with all the clients, to se if the delivery time its between IV_R1 and IV_R2, the problems is that I dont have the same client information, it does not allowme to relate. 

 

Thanks so much

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    I am sorry but i cannot understand why the answer should be 8:30 and 11:00.  Please explain.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi, 

       

      Sorry, the 2 datasets looks like these:

      Dataset 1:

      ClientIVR_1FVR_1
      1000128:30:0011:00:00
      .........

       

      Dataset 2:

      ClientDelivery hour
      10001216:51:29
      .....

       

      And the result would look like this:

       

      ClientDelivery hourIVR_1FVR_1
      10001216:51:298:00:0016:00:00
      ...........
      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        8 years ago

        Hi,

         

        So when the client ID in Table 2 matches the client ID in Table 1, you want to extract the IVR_1 and FVR_1 from Table 1.  Am i correct?  If yes, then share a dataset (which i can paste into MS Excel) with matching clinet ID's in both tables.