Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Merging of Columns

Hi All,   I am trying to merge columns from different queries (used four queries) in Power BI Desktop using Manage Relationship by Many to Many Cardinality. But, could find that only common data ca...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Eads,

     

    Found the solution for merging columns from different queries having different number of columns.

     

    Below is the code:

     

    TABLE = DISTINCT(
		  UNION ( SELECTCOLUMNS(TABLE1,"COLUMN",TABLE1[COLUMN]),
                           SELECTCOLUMNS(TABLE2,"COLUMN",TABLE2[COLUMN])
			)
		  )

    After giving the code, need to manage relationships using all queries by Many to Many Cardinality.

     

     

    If this post helps, then please consider Accept it as the solution to help the others to find it more quickly.

     

    Regards,

    Vineetha.

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Eads,

 

Found the solution for merging columns from different queries having different number of columns.

 

Below is the code:

 

TABLE = DISTINCT(
		  UNION ( SELECTCOLUMNS(TABLE1,"COLUMN",TABLE1[COLUMN]),
                           SELECTCOLUMNS(TABLE2,"COLUMN",TABLE2[COLUMN])
			)
		  )

After giving the code, need to manage relationships using all queries by Many to Many Cardinality.

 

 

If this post helps, then please consider Accept it as the solution to help the others to find it more quickly.

 

Regards,

Vineetha.

 

v-eachen-msft's avatar
v-eachen-msft
Community Support
7 years ago

Hi Anonymous ,

 

I am glad that you found the right solution for your question.

 

Best Regards,

Eads

 

If my previous post helps, then please consider Accept it as the solution to help the others to find it more quickly.