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

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi, 

     

    Yes, you are correct, i need the exact thing

     

    Can you give some mail address, cause the data is too big it does not allow me to paste

    Or how can I share the datasets with you?

     

     

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

    Hi,

     

    Upload the file to Google Drive/One Drive and share the download link here.

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

    Hi,

     

    You may download my solution file from here.  Hope this helps.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi, 

     

    Thanks Ashish_Mathur, the link you sent is the same file's direcction i sent

     

     

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

    Hi,

     

    The link i sent you contains the solution.  Click on PowerPivot > Manage and you will see the solutio in the columns IVR and FVR in the Delivery tab.

     

    Hope this helps.