Forum Discussion
Query's - Create 1 query out of multiple (different) Excel sheets.
Hi everyone,
I'm busy using PowerBI forums now.. but I'm not finding the right answer.
I'm having 2 Excel sheets, these are both output out of an software program. I'm rebuilding these Excel sheets in Query's, to use a live connection later.
The Excel sheets are both really different. One of the only things which is the same are the use of dates (long written).
How can I combine 2 Excel sheets to create 1 Query?
5 Replies
Anonymous ,
Create 2 queries, and then either merge or append them. Let me refer you to this post, where I answered a close question.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielHi Nathaniel_C
Thanks for you help!
It sadly doesn't work, but not for my Excel sheets.
I'm having the following issue;
Excel sheet 1 is having loads of amounts (20 to 30 rules) per weekly number.
Excel sheet 2 is only having 1 invoice amount per weekly number.
If I merge or append, there will be 20 to 30 times the same invoice amount on the weekly numbers which are connected to the invoice amount.
The total amount will then be 20 to 30 times higher than it should be.
Is it possible to share sample files
