Forum Discussion
Combining data from multiple tables to a single card
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.
Hi Anonymous
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!
Anonymous 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)
3 Replies
bheepatelResolver IV
Hi Anonymous
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
Super User
Anonymous 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)