Solved: How can I use IF and Contains together

gauravnarchal · ‎11-03-2022

Hello - How can I use IF and Contains together when writing a dax?

So the dax should be

IF table 1 , coulmn email contains "@gmail.com" then return "Gmail" else other

Table 1

Email

PaulDBrown · ‎11-03-2022

As a calculated column:

Gmail? = IF(CONTAINSSTRING('Table 1'[Email], "gmail"), "gmail", "Other")

As a measure:

gmail measure = 
IF(CONTAINSSTRING(MAX('Table 1'[Email]), "gmail"), "gmail", "other")

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

PaulDBrown · ‎11-03-2022

As a calculated column:

Gmail? = IF(CONTAINSSTRING('Table 1'[Email], "gmail"), "gmail", "Other")

As a measure:

gmail measure = 
IF(CONTAINSSTRING(MAX('Table 1'[Email]), "gmail"), "gmail", "other")

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

How can I use IF and Contains together