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(...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Is this what you were expecting?

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity 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   

       

      • mdhevara's avatar
        mdhevara
        Frequent Visitor
        6 years ago

        This is the DAX code i have it works for everything excet for the 1A6 (or) 2A2 i.e when the number is preceded by the alphabet

         

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