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.
Hi all,
In order to use a the operator "IN" in a DAX measure I need a list after that operator.
I am trying to use a string stored in my model as a list. How could I convert a string into a list in a measure?
The function we want to use: PRODUCT_TABLE[Name] IN Product_List
Solved! Go to Solution.
Hi @QuentinDSC,
Have you tried using FIND or Search instead of IN?
FIND(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])
FIND is case-sensitive.
SEARCH(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])
This function does not check uppercase and lowercase letters.
I managed to do what I wanted to. Thank you all 🙂
Hi @QuentinDSC,
Have you tried using FIND or Search instead of IN?
FIND(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])
FIND is case-sensitive.
SEARCH(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])
This function does not check uppercase and lowercase letters.
HI @QuentinDSC ,
Please refer to this article from SQL BI.
https://www.sqlbi.com/articles/the-in-operator-in-dax/
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |