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
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
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
        ...........