Forum Discussion

mdhevara's avatar
mdhevara
Frequent Visitor
6 years ago

ISERROR bug in Desktop Version: 2.79.5768.721

Hello, I am trying to write a simple DAX statement and it fails for some of the values (especially when the values start with a number)

 

TEST = IF (ISERROR(MID(column,1,2)+0),MID(column,1,1), MID(column,1,2))

Sample values, the above solution works for C1A1 however fails for 6A2 and 1A1

C1A1 

6A2

1A1

C3F4

 

Am i missing something (or) is there a bug in ISError

Thanks,

Md

Need Help

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    Hmm, I will test but on different version:
    2.79.5768.1082 64-bit (March 2020)
    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago

      Huh, look at that, 6A is .25... I don't think it is a bug in ISERROR, seems like something else? What are you trying to accomplish?

       

      • mdhevara's avatar
        mdhevara
        Frequent Visitor
        6 years ago

        Thanks Greg for taking a look. Im trying to return the number before or after the alphabet. So my data can be like below so all i care about is the first 3 characters and if it has numbers return it

        Input     Output

        23C1    23

        2A2       2

        A8C1     8

        B91       91

        BNC     

        CHK