Forum Discussion

Regular Visitor

2 years ago

Solved

Text. Combine

Hi All, I'm starting to explore the world of Power-BI and Power Querries. I have a table for the administative structures with the different levels in each collumn. To take an example for switzerla...

Khushidesai0109
2 years ago
Hiiii BenZEN

Try this

= Text.Combine({
Text.Upper([ADM4_EN]),
Text.Start(Text.Upper([ADM3_EN]), 5),
Text.Start(Text.Upper([ADM2_EN]), 3),
Text.Start(Text.Upper([ADM1_EN]), 3)
}, "-")

Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Regular Visitor

2 years ago

Thanks ! it worked.... Brackets are my devil ^^

Appreciate this super quick reply. Have a nice day