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,

 

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.