How to format text in PoewrBI

[NoobAnalyst01]

Hello,

I have a list a region code, the data type is text.

As you can see it shows as 80, but actually it should be 080 in excel, i already change the datatype to text in powerbi data modeling, but it still show as 80.

I know in excle I can use =TEXT(80,"00#") to let it become 080, so if the zone number is 2, it will become 002, just wonder how can i do the same thing in power bi

Thanks

Frank

[Phil_Seamark · Accepted solution]

Hi @NoobAnalyst01

Please try

 = FORMAT( INT("80") , "00#" )