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
Super User
8 years ago

Hi,

 

Using the query editor, append the Clients column from both tables and remove duplicates.  Now create a realtionship from the Clients from of both tables to this third table.  In any visual, drag the clients column from the third table.

 

Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello Ashish_Mathur

 

What do you mean with append both colums... create a thrid appended table with all the clients?

So, then what is the way to combine the values of the each same Client with the columns of the two different tables

 

For example: 

I want to have the line like these

10002 10:00 14:00  11:00 1 

 

Please Help me

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super 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
        Super User
        8 years ago

        Hi,

         

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