Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi @AtchayaP ,
Here's the formula:
both =
var tmp = SUMMARIZE('Table','Table'[name],'Table'[content type],'Table'[type])
return
CONCATENATEX(FILTER(tmp,[name]=EARLIER('Table'[name])),'Table'[type],"+")
Best Regards,
Jay
Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform.
Greeting,
Rachel Gomez
Hi @AtchayaP ,
Here's the formula:
both =
var tmp = SUMMARIZE('Table','Table'[name],'Table'[content type],'Table'[type])
return
CONCATENATEX(FILTER(tmp,[name]=EARLIER('Table'[name])),'Table'[type],"+")
Best Regards,
Jay
@AtchayaP Use CONCATENATEX
Can you tell me the full expression how to use it
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!