Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
 
					
				
		
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
| A | B | Col3, Col4 | ||
| B | Col1, Col3, Col4 | |||
| A | C | Col2, Col4 | ||
| A | Col2, Col3, Col4 | |||
| B | D | Col1, Col3 | 
Solved! Go to Solution.
pls see the attachment below
Proud to be a Super User!
 
					
				
		
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
 
					
				
		
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?
Proud to be a Super User!
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 | 
Proud to be a Super User!
Col1 Col2 Col3 Col4 Wanted
| A | B | Col3 | ||
| B | Col1, Col3 | |||
| A | C | Col2 | ||
| A | Col2, Col3 | |||
| B | D | Col1, Col3 | 
Thank you ryan_mayu 😉
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 84 | |
| 49 | |
| 36 | |
| 31 | |
| 30 |