Forum Discussion

juhoneyighot's avatar
juhoneyighot
Icon for Helper III rankHelper III
2 years ago
Solved

Problem with DAX IFERROR formula

I'doing this IFERROR DAX formula: Phase _ = IFERROR(IF('stx__legacy_fsjob'[# of _]="","", FIND("~", SUBSTITUTE('stx__legacy_fsjob'[_JobType_txt],"_","~",'stx__legacy_fsjob'[# of _]-1))),'stx__legacy...
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI juhoneyighot,

    I think this should be more related to your data source connection mode. AFAIK, direct query mode has limited the Dax functions usage.
    For this sceniaro, you can't create calculate columns in direct query with complex Dax functions. I'd like to suggest you use measure expression instead.

    Regards,

    Xiaoxin Sheng

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

Hi juhoneyighot 
Please try

Phase _ =
IFERROR (
    IF (
        'stx__legacy_fsjob'[# of _] = BLANK (),
        "",
        FIND (
            "~",
            SUBSTITUTE (
                'stx__legacy_fsjob'[_JobType_txt],
                "_",
                "~",
                'stx__legacy_fsjob'[# of _] - 1
            )
        )
    ),
    'stx__legacy_fsjob'[_JobType_txt]
)
  • juhoneyighot's avatar
    juhoneyighot
    Icon for Helper III rankHelper III
    2 years ago

    tamerj1 

    This error occurs when I tried the formula

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      2 years ago

      juhoneyighot 
      Please try

      Phase _ =
IFERROR (
    IF (
        'stx__legacy_fsjob'[# of _] = BLANK (),
        "",
        FIND (
            "~",
            SUBSTITUTE (
                'stx__legacy_fsjob'[_JobType_txt],
                "_",
                "~",
                'stx__legacy_fsjob'[# of _] - 1
            )
        ) & ""
    ),
    'stx__legacy_fsjob'[_JobType_txt]
)