topic Re: Text contains text or numer in dax in DAX Commands and Tips

Text contains text or numer in dax

superME79 — Fri, 08 Oct 2021 10:32:08 GMT

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?

Re: Text contains text or numer in dax

Anonymous — Fri, 08 Oct 2021 11:52:54 GMT

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"

)

Re: Text contains text or numer in dax

Anonymous — Mon, 11 Oct 2021 09:20:11 GMT

For Measure :

superME79

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