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

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]
)
  • juhoneyighot's avatar
    juhoneyighot
    Icon for Helper III rankHelper III
    2 years ago

    tamerj1 

    Hello! this error occurs.