Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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 can be filtered in report. 

 

Columns from Different Queries and SlicerColumns from Different Queries and Slicer

Please check the screenshot where I am not able to filter CC Field using slicer.

Kindly, suggest me some solution.

 

Regards,

Vineetha

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

 

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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.

 

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.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
Anonymous
Not applicable

Hi Eads,

 

This solution works only for queries haivng equal no of columns but not in other case.

Kinldy let mw know, if theres a way to achieve this.

 

Regards,

Vineetha

v-eachen-msft
Community Support
Community Support

Hi @Anonymous ,

 

You need to create a new table with Union() function to be a slicer.

SlicerTable =
DISTINCT ( UNION ( AR, cc, Inventory, 'Sales CC' ) )

Then create relationships with other four tables. The relationships must be active ones.

 

merge.PNG

 

Now you can create your reports.

 

report1.PNG

 

Best Regards,

Eads

 

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

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.