Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey guys,
I have the following Dax formula that attributes an e-mail to an e-mail type, but I wonder if I could rewrite it better:
Solved! Go to Solution.
Hi @Anonymous
You can try the following column.
Create a new calculated column in 'Maia Data table
Type E-mail= var a={"sbz","mailstreet","menzis",···}
return IF(OR(CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"onbekend"),'Maia Data'[maia.Persoon.e-mail] = BLANK ()),"onbekend",IF(COUNTROWS(FILTER(a,CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],[Value])))>0,"Zakelijk"))
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
You can try the following column.
Create a new calculated column in 'Maia Data table
Type E-mail= var a={"sbz","mailstreet","menzis",···}
return IF(OR(CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],"onbekend"),'Maia Data'[maia.Persoon.e-mail] = BLANK ()),"onbekend",IF(COUNTROWS(FILTER(a,CONTAINSSTRING('Maia Data'[maia.Persoon.e-mail],[Value])))>0,"Zakelijk"))
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This helped me a lot!
Something like that?
Email Type =
VAR EmailAddress = 'Maia Data'[maia.Persoon.e-mail]
RETURN
SWITCH(
TRUE(),
OR(
CONTAINS(EmailAddress, "unive"),
CONTAINS(EmailAddress, "vanderdussen"),
CONTAINS(EmailAddress, "vecozo"),
CONTAINS(EmailAddress, "vektis"),
CONTAINS(EmailAddress, "vgz.nl"),
CONTAINS(EmailAddress, "zorg"),
CONTAINS(EmailAddress, "zn.nl"),
CONTAINS(EmailAddress, "schuldenlab"),
CONTAINS(EmailAddress, "owmachterhoek.nl")
), "Zakelijk",
"Privé"
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
37 | |
25 | |
19 | |
14 | |
8 |
User | Count |
---|---|
69 | |
48 | |
44 | |
19 | |
15 |