Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
  • bheepatel's avatar
    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! 

  • parry2k's avatar
    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)