Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hi,
The below should be relatively easy to fix in DAX but somehow I do not succeed.
For simplicity sake here is a dummy fact table:
ID | Content | Required Column |
1 | Text1,text2text3,text4,text5 | 2plus4 |
2 | Text1 | other |
3 | Text2,Text4 | 2plus4 |
4 | Text1,text5 | 1pus5 |
5 | Text1,Text4,Text5 | 1plus5 |
6 | Text0Text2text99 | Text2 |
7 | Text 18 | Other |
I try to get a new (calculated) column that checks in the following order:
Your help is appreciated,
(Worst)Kees
Solved! Go to Solution.
@Anonymous , A new column like
Switch( True() ,
containsstring([Content],"text2") && containsstring([Content],"text2") , "2plus4",
containsstring([Content],"text1") && containsstring([Content],"text5") , "1plus5",
containsstring([Content],"text2"), "text2",
"Other")
@amitchandak thanks, this is brilliant.
Do you have any idea why "?" or "/?" is not working for my "text2" while if I use any other combination of characters, it works? No big deal (I created a workaround) but just curious.
Kind regatds & thanks again,
(Worst)Kees
@Anonymous , A new column like
Switch( True() ,
containsstring([Content],"text2") && containsstring([Content],"text2") , "2plus4",
containsstring([Content],"text1") && containsstring([Content],"text5") , "1plus5",
containsstring([Content],"text2"), "text2",
"Other")
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
11 | |
11 | |
8 | |
8 | |
8 |