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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.