Excel TEXT function - equivalent in DAX

[darylmc]

Hi All,

I'm looking to replicate =TEXT(A2,"0000") in DAX in order to make sure a string column has at least 4 characters. What is the function to achieve this?

Thanks in advance

[amitchandak · Accepted solution]

Use M, in transform data mode

https://docs.microsoft.com/en-us/powerquery-m/text-format

[MFelix · Accepted solution]

Hi @darylmc,

In DAX:
FORMAT(TABLE[COLUMN], "0000")

In query editor:
Text.PadStart (column, 4, 0)

[amitchandak · Accepted solution]

Use M, in transform data mode

https://docs.microsoft.com/en-us/powerquery-m/text-format

[Anonymous]

Use the FORMAT function.

Best
D

[Anonymous]

We have len function to check the length of string.
New column=if(len(table[oldcolumn])<4,blank(),table[oldcolumn])

Or you can do this in power query as well

= if Text.Length([Projekt_ID]) <4 then "" else [project_id]