Text. Combine

[BenZEN]

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 switzerland, i would have a collumn [ADM4_EN] for the village name, a collumn [ADM3_EN] for the communal name, a collumn [ADM2_EN] for the Districts and a collumn [ADM1_EN] for the canton name

I'm tryimg to create a new custom collumn to generate an unique location code in the form : the VILLAGE name in full - COMMUNE name (first 5 letters)-DISTRICT name (first 3 letters)- Cnaton name (first 3 letters). SHould look like this : VILLAGE-COMMUN-DIS-CAN

After some digging on web based help sites, i got down to this formula : 

=Text.Combine({text.upper[ADM4_EN],Text.Start(Text.Upper[ADM3_EN],5),ext.start(text.upper([ADM2_EN],3)),text.start(text.upper([ADTM1_EN],3)}, "-")

But there seems to be an error on the last bit as it shows me 'token ',' expexted when i hover on the "-" . 

Any suggestions ? 

Thanks !!

[BenZEN]

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

Appreciate this super quick reply. Have a nice day 

[Khushidesai0109 · Accepted solution]

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