Forum Discussion
Combine different tables with similar data
I collect data from different equipments in separated files......(each file has the same columns structure) and these data are used to create some KPIs. I need to see all these data in a visual that allows me to see KPIs from all equipments together and each one separated (as a slicer).....I mean, for example...........Production from equipment A, B and C and also to only 1.
Is there a easy way to do that?
If you have data from A, B, C as separate files, generally, you want to append these files together so that all of the data loads into the same table.
Here are a couple of articles covering this in much more detail:
2 Replies
- AlexisOlson
Super User
If you have data from A, B, C as separate files, generally, you want to append these files together so that all of the data loads into the same table.
Here are a couple of articles covering this in much more detail:
v-jingzhangCommunity Support
Hi Anonymous
If the files are not from the same folder, you can connect to them separately, then use Append Queries feature to append all of them into a single table. Use a slicer to filter equipment column.
Append queries - Power Query | Microsoft Learn
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!