Forum Discussion
Solved
Help with ISNUMBER function in DAX
Hi, I am trying to extract month and year form two text fields. It is either embedded in field1 or field2. I have to try field one first and if it can't be extracted from field1, then it should be e...
Right, so ISNUMBER isn't working because it is testing if it is a number. It is not, it is text. You probably want:
Column = IF( ISERROR(VALUE(LEFT([Field1],4))), LEFT([Field2],4), LEFT([Field1],4) )See attached.
Right, so ISNUMBER isn't working because it is testing if it is a number. It is not, it is text. You probably want:
Column =
IF(
ISERROR(VALUE(LEFT([Field1],4))),
LEFT([Field2],4),
LEFT([Field1],4)
)
See attached.
Thanks a ton Greg
- My pleasure! Those kinds of nit things can be maddening! 🙂