Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two tables (Table A and Table B), Both tables have exactly the same columns and all columns except one column are decimal numbers. The tables are related via the one non-decimal column called names.
I want to add (sum) each column from Table A and Table B together to create a third Table C, with the one non-decimal number column, i.e.
Table C[Column 1] = (Table A[Column1] + Table B[Column1]) where Table A [Names] = Table B[Names].
Is this possible? if so, how do I do it?
Thanks
Phil
Solved! Go to Solution.
Hi @pburness
First, create a Merge Query as below.
Then try to add an Append Query as below:
Then Merge the two queries as below and remove Table columns as requested.
Last, Group the new query as below. You may need to do it with M language in Advanced Editor.
Regards,
Cherie
Hi @pburness
First, create a Merge Query as below.
Then try to add an Append Query as below:
Then Merge the two queries as below and remove Table columns as requested.
Last, Group the new query as below. You may need to do it with M language in Advanced Editor.
Regards,
Cherie
Hi @pburness
You may try to use Merge Queries in Query Editor as below.
Then expend the table without name column and filter all values without the null values.
Create custom columns to sum the values from 2 table as requested.
Regards,
Cherie
Thanks Cherie,
This works, but I was hoping there was a way to automate the task. There are 80 columns in each table, so not a huge burden, but still a bit of a chore...
Phil
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |