Text contains text or numer in dax

[superME79]

Hello,
I need help, I have a column that contains numbers and text, it is formatted as text, I need to check in dax if each value of the column is a number or a text.
I tried creating a calculated column but when it transforms it freezes because it gives an error on the type.

do you know a function that does this?

[Anonymous · Accepted solution]

Hello, if you do not want to do this in PQ, I would create a calculated column as follows:

Text vs Numeric =

SWITCH (

TRUE (),

ISERROR ( VALUE ( SampleData[Column Name] ) ), "Text",

"Numeric"

)

[Anonymous · Accepted solution]

For Measure :

@superME79 

Measure = IF(ISERROR(INT(MAX('Table'[name]))),"String","Integer")

[Anonymous · Accepted solution]

Hello, if you do not want to do this in PQ, I would create a calculated column as follows:

Text vs Numeric =

SWITCH (

TRUE (),

ISERROR ( VALUE ( SampleData[Column Name] ) ), "Text",

"Numeric"

)