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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

retrieve column name if empty

Hi there,

 

I have some difficulties to combine text columns name with the result I want. If someone could help me to point me to the right direction please 🙂

 

So I have this table :

Col1    Col2  Col3  Col4        Wanted

AB  Col3, Col4
 B  Col1, Col3, Col4
A C Col2, Col4
A   Col2, Col3, Col4
 B DCol1, Col3

 

1 ACCEPTED SOLUTION

pls see the attachment below





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

Proud to be a Super User!




View solution in original post

9 REPLIES 9
Anonymous
Not applicable

Hi ryan_mayu,

Thanks for this exemple, it help me a lot, i have a last need, i need to get a specific empty column name ( Col1, Col2) not all of them, what is the fonction to add for that please ?

Regards,

ZeNab

Anonymous
Not applicable

Hi ryan_mayu,

Thanks for this exemple, it help me a lot, i have a last need, i need to get a specific empty column name not all of them, what is the fonction to add for that please ?

Regards,

ZeNab

what's the expected output based on the sample data you provided?

Could you pls update?





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

Proud to be a Super User!




Anonymous
Not applicable

based on the example, I need to check a specific empty column name ( Col1, Col2,Col3) not all of the empty column.

Thanks alot

sry, still not understand your request. could you pls update the table below?

 

Col1    Col2  Col3  Col4        Wanted

A B     Col3, Col4
  B     Col1, Col3, Col4
A   C   Col2, Col4
A       Col2, Col3, Col4
  B   D Col1, Col3




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

Proud to be a Super User!




Anonymous
Not applicable

Col1    Col2  Col3  Col4     Wanted

AB  Col3
 B  Col1, Col3
A C Col2
A   Col2, Col3
 B DCol1, Col3

pls see the attachment below





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

Proud to be a Super User!




Anonymous
Not applicable

Thank you ryan_mayu 😉

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ryan_mayu
Super User
Super User

@Anonymous 

here is a workaround for you, pls see the attachment below





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

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors