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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
BI21
New Member

Extract unique values from multiple columns

Hello Power BI community,

I have been trying for some time now to figure out the solution to this problem (I am new to Power BI and DAX) but I could not find the solution myself or on the internet. The problem is pretty basic:

I have a table and I would like to extract the unique values from some of the columns. For example, from the following table I would like to have the unique values of columns 1, 2 and 3, so the answer would be A, B, C, D.

A

DC1
ACA2
BAB3
CBC4
DBA5
DBB6

 

Thanks in advance (also for redirecting me to relevant posts that I might have missed)!

 

2 REPLIES 2
Idrissshatila
Super User
Super User

Hello @BI21 ,

 

like for example you could in power query, duplicate the table you have then remove all columns except the one you want to extract the values from then right click on this column and choose remove duplicates.

 

so you'll have every unique value in this column.

Idrissshatila_0-1681823001584.png

 

 

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Thank you for your hint! However, this only works when I apply it to one of the columns, not to several columns. So when I mark the first two columns of the example data and apply "Remove duplicates", it only removes the last row because the entry "D (in column 1) B (in column2)" is indeed a duplicate but the result is still a table. I want as answer only "A, B, C, D"

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.