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
Good Day guys!
Can someone help me how I can merge or combine 2 different data in a column? example belowletters (data) | lettersv2 (output)
Thanks in advance!
Solved! Go to Solution.
Hi @RanHo
You can try this, split a column based on digit and non-digit combinations
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @RanHo
You can try this, split a column based on digit and non-digit combinations
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
@RanHo I'm not following what you're expected output is here - could you please clarify the result you're expecting to see?
@ebeery Sorry Sir, the output I want to achieve is the column "LETTERSV2" wherein the the column "LETTERS" is a raw data. I want to merge the A1, A2 and A3 into A only.
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!