Combining data from multiple tables to a single card

[MarkCalvert1988]

Good Afternoon,

I have numberous data tables from various suppliers with lots of different information, one of these is DocumentID.

Now my ain is to have a card counting all the document ID's from all the suppliers. Then I would like to have a slicer where I select the supplier and the car shows the count of DocumentID from that supplier selected in the slicer.

(At the moment I have four suppliers, each with thier own tables, but the common column of DocumentID).

Any suggestions here? Many thanks in advance.

[bheepatel · Accepted solution]

Hi @MarkCalvert1988 

I would suggest using Power Query. What you can do is create a custom column for each of those 4 tables where the custom column will simply be the name of that client (ClientName).

You can then create a fifth query where you append all those 4 tables into one and only keep the following two columns:

• ClientName
• DocumentID

Hope this helps! 

[parry2k · Accepted solution]

@MarkCalvert1988 the best approach would be to append the table together in power query and then you can get total count of document and able to slicer it by supplier as well, basically it will be one giant table (append of all 4 tables from various suppliers)

[MarkCalvert1988]

Thanks, a powerquery was just the ticket, appended them together and now works like a dream!

[bheepatel · Accepted solution]

Hi @MarkCalvert1988 

I would suggest using Power Query. What you can do is create a custom column for each of those 4 tables where the custom column will simply be the name of that client (ClientName).

You can then create a fifth query where you append all those 4 tables into one and only keep the following two columns:

• ClientName
• DocumentID

Hope this helps!