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

Need Help

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)

4 Replies

MFelix
Super User
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
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]
Anonymous
Not applicable
6 years ago
Use the FORMAT function.

Best
D
amitchandak
Super User
6 years ago
Use M, in transform data mode

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

Forum Discussion

Excel TEXT function - equivalent in DAX

4 Replies

Related content

DAX equivalent to the Excel Proper function

Excel equivalent functions for DAX

DAX SQL window function equivalent

Equivalent of Tableau Function: Window_sum()

Containsstring dax equivalent in Excel Power Pivot