Solved: Re: Stateement equivalent

Anonymous · ‎08-17-2018

Hey,

I have the following expression in QlikView and I need it's equivalent in PowerBI. DIRECTINDIRECT needs to be a new column.

if(SUBPSL='Man',if(DIRECT_INDIRECT= 'Direct' , 'DIRECT', if(DIRECT_INDIRECT= 'Indirect', 'INDIRECT' ))) as DIRECTINDIRECT

Any Suggestions? Thank You!

MFelix · ‎08-17-2018

Hi @Anonymous,

Try to use this formula:

DIRECTINDIRECT =
SWITCH (
    TRUE ();
    'Table'[SUBSPL] = "Man"
        && 'Table'[DIRECT_INDIRECT] = "Direct"; "Direct";
    'Table'[SUBSPL] = "Man"
        && 'Table'[DIRECT_INDIRECT] = "Indirect"; "Indirect"
)

This is a calculate column

Regards,

MFelix

Regards

Miguel Félix

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português

View solution in original post

MFelix · ‎08-17-2018