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
UsePowerBI
Post Prodigy
Post Prodigy

How to perform actions on 'every column of a table' regardless of the number and name of the columns

Hello

 

How to perform actions on 'every column of a table' regardless of the number and name of the columns?

 

I would like for example:

1) get the unique values of each column

2) get the first give values of each column

etc

 

Thanks!

5 REPLIES 5
UsePowerBI
Post Prodigy
Post Prodigy

@ryan_mayu 

 

Please find below the source table and I want to output the following lists of unique values per column. Please note I want the solution to work regardless of the table and columns!

 

Col1Col2Col3
123
234
123
234

 

Col1
1
2

 

Col2
2
3

 

Col3
3
4

do you want to combine the columns to a new table?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@ryan_mayu yes or I may do additional transformations once I get these unique value lists, I thank you! 

@UsePowerBI 

i am not good at M. However, here is a workaround for you

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ryan_mayu
Super User
Super User

could you pls provide the sample data and expected output?

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

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.