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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors