How to combine two column from two different table into one.

Question

I have created a two different distinct column from two different table, now i want to show in my chart the combine sales value from both tble and want to combine those two distinct column into one..how do i do that.

For example in my chart i am showing the total sales value (Table A Sales+TableBSales) from both the table, now i want to show in legend the combine category name, but i am not able to do that

any idea how to do that?

v-sihou-msft · Accepted Answer

asta
&nbsp;
Merge Queries is like joining two different tables. For your requirement, you should use "Append Queries" to combine two colums values into one. Please see: Shape and combine data in Power BI Desktop
&nbsp;

Regards,

Forum Discussion

How to combine two column from two different table into one.

2 Replies

Related content

Combine Column

Combining Column Data

Combine files with different column structure

Combine columns into 1

Combining Columns in Different Tables