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

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))

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      6 years ago

      What about this?

       

      Column = 
    VAR __1 = IFERROR(LEFT([Input],1)+0,-1)
    VAR __2 = IFERROR(MID([Input],2,1)+0,-1)
    VAR __3 = IFERROR(MID([Input],3,1)+0,-1)
RETURN
    SWITCH(
        TRUE(),
        __1 = -1 && __2 = -1 && __3 = -1,BLANK(),
        __1 <> -1 && __2 <> -1 && __3 = -1,VALUE(__1 & __2),
        __1 = -1 && __2 <> -1 && __3 = -1,__2,
        __1 = -1 && __2 = -1 && __3 <> -1,__3,
        __1 = -1 && __2 <> -1 && __3 <> -1,VALUE(__2 & __3),
        __1
    )

      See attached PBIX.