Forum Discussion

united2win's avatar
united2win
Icon for Helper III rankHelper III
7 years ago
Solved

How to link two tables together?

Hi,    Any help will be greatly appreciated. I have the following table:   Client Service Required Country Status Company A VAT Registration DE Closed  Company A VAT Registration ...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    In the second table it seems like you need to split your second column on the dash. Then you are going to need to do something to get the resulting second column from that split into rows, something like an unpivot or pivot. ImkeF should be able to help.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Create a table with single unique values, probably with distinct Client names.

 

Then, create a link between them with cardinality one to many for both tables. Use this variable as the filter or variable in the matrix, and it will work for both tables.

 

PBI works better doing Star Structure for Databases. Look it up and understand the logic.

 

You can also watch videos from this page: https://www.youtube.com/watch?v=vjBprojOCzU (this video should help you)