Forum Discussion
Using Same Raw Data on Merged Queries with Multiple Queries
Hi, jpalaci1
According to your description, I guess that you want to achieve the same table as the desired table you posted in the Power Query of Power BI, do you mean this?
If so, you can take a look at my steps to get the table and find if it’s useful:
- Go to the Power query, click on the “Append query”, append the three tables:
Then go to the three tables, add a [Year] column for each, like this:
- Click on “Merge query as a new table” and merge and expand table:
- Do the Merge and append operation again, like this:
And you can get what you want.
You can download my test pbix file here
If this is not what you want, you can explain your requirement in detail with sample pictures so that we can help you in advance.
Thank you!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, jpalaci1
According to your description, I guess that you want to achieve the same table as the desired table you posted in the Power Query of Power BI, do you mean this?
If so, you can take a look at my steps to get the table and find if it’s useful:
- Go to the Power query, click on the “Append query”, append the three tables:
Then go to the three tables, add a [Year] column for each, like this:
- Click on “Merge query as a new table” and merge and expand table:
- Do the Merge and append operation again, like this:
And you can get what you want.
You can download my test pbix file here
If this is not what you want, you can explain your requirement in detail with sample pictures so that we can help you in advance.
Thank you!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much!