Forum Discussion
Joining Table using DAX
I'd start here:
https://docs.microsoft.com/en-us/powerquery-m/power-query-m-reference
You will want to use Append or Merge. Load your data and go to Power Query ( Home-->Edit Queries-->Edit Queries). That will take you to Power Query and then in there go to the Home tab-->Combine (far left) and mess aroudn with the Merge and Append buttons. Each will take you to a wizard which should help greatly. Give it a shot and come back with any questions.
You'd probably be better off using Power Query for this. Have you tried there?
AnonymousNo, How do I do that. New to all this.
I'd start here:
https://docs.microsoft.com/en-us/powerquery-m/power-query-m-reference
You will want to use Append or Merge. Load your data and go to Power Query ( Home-->Edit Queries-->Edit Queries). That will take you to Power Query and then in there go to the Home tab-->Combine (far left) and mess aroudn with the Merge and Append buttons. Each will take you to a wizard which should help greatly. Give it a shot and come back with any questions.
Hi,
this is a good way to join queries!
Is there a way to join a query and a calculated table?
What I got is a query "query1" on quarterly based data. What I need is a monthly base.
So I build a date table and build another table "calc_table" with a groupby() on the month field and a calculated coloumn for the quarter names like in the "query1".
Now I tried to join "query1" and "calc_table" but I found no way to do that. Any ideas on that?
Best,
b.