Forum Discussion
Combining data from multiple tables to a single card
- 6 years ago
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!
- 6 years ago
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)
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)
Thanks, a powerquery was just the ticket, appended them together and now works like a dream!