topic Re: multiple if condition with AND, cointains, endwith operator in DAX Commands and Tips

multiple if condition with AND, cointains, endwith operator

sheenajose — Wed, 27 Jan 2021 12:48:54 GMT

how to achieve the below if condition in power bi through Custom Column or Condition column

if my dept column end with hr or lab AND the title column contains admin then the result is pass else fail

IF TEXT.ENDWITH([columnDept] = "hr" AND TEXT.CONTAIN([columnTitle] = "admin" then "pass"

ELSE IF TEXT.ENDWITH([columnDept] = "lab" AND TEXT.CONTAIN([columnTitle] = "admin" then "pass"

ELSE "fail"

AlB — Wed, 27 Jan 2021 13:10:24 GMT

= if (Text.EndsWith([columnDept], "hr") or Text.EndsWith([columnDept], "lab")) and Text.Contains([columnTitle], "admin") then "pass" else "fail"

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers

AlB — Wed, 27 Jan 2021 15:16:43 GMT

I'd need to see some sample data with the expected result

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers