Forum Discussion

Frequent Visitor

6 years ago

Solved

Excel TEXT function - equivalent in DAX

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
6 years ago
Use M, in transform data mode

https://docs.microsoft.com/en-us/powerquery-m/text-format
MFelix
6 years ago
Hi darylmc,

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

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

Anonymous

Not applicable

6 years ago

Use the FORMAT function.

Best
D

Related content