Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have two measures that return country names based on max formulas , some of the returned values contain multiple countries , seperated by a comma. so my current measure i am using is not matching any data which has multiple countries as it would not be an exact match.
Example :
Measure -- Op Country = United States
Measure -- Max Base = Mexcio,United States
so my measure :
Solved! Go to Solution.
Hi , @Pandadev
You can try function CONTAINSSTRING :
Matched Country = IF(CONTAINSSTRING([M_maxbase],[M_op_country]),"Yes","No")
The result will show as below:
By the way ,CONTAINSSTRING is not case-sensitive.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Pandadev Yes, you could use FIND, SEARCH or even SUBSTITUTE
Thanks , could you please show me an example of how one of these formulas would look
Hi , @Pandadev
You can try function CONTAINSSTRING :
Matched Country = IF(CONTAINSSTRING([M_maxbase],[M_op_country]),"Yes","No")
The result will show as below:
By the way ,CONTAINSSTRING is not case-sensitive.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |