DAX IF Text Contains A or B then C Else D

[AW1976NOVA]

Hello,

I need help writing a Dax custome column.

I need it to essentially say:

= IF ('CSR_Data_Audit_List'[LOB] = "A" or "B" then return "C", Else return "D".

Can you please assist?

[speedramps]

Answer =
VAR mylob = SELCETDVALUE('CSR_Data_Audit_List'[LOB])
RETURN
IF(mylob IN {"A","B"},
"C",

"D"
)

Please click thumbs up and accept as solution buttons, Thank you! 😀

[tackytechtom · Accepted solution]

Hi @AW1976NOVA ,

How about something like this:

Column = IF ( CSR_Data_Audit_List[LOB] = "A" || CSR_Data_Audit_List[LOB] = "B", "C", "D" )

Does this solve your issue? 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/