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,
still new to this DAX language even I do understand more and more day by day I feel still often lost.
Probably for most of you guys it is very easy to solve my following question.
I want to get a value if a column contains text - any text no specific.
i started like this:
if(
search(
"part of text";table[column]);1;0)
The pic below shows this sort of text i have as condition...
but unfortunately ans "error".
Would be nice if anyone can help me out.. even u may laugh about it..
cheers, bb
Solved! Go to Solution.
Hi @Anonymous ,
Check out this post and the answers for either Power Query or DAX: https://community.powerbi.com/t5/Desktop/Check-whether-characters-are-numeric/td-p/327628
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
Check out this post and the answers for either Power Query or DAX: https://community.powerbi.com/t5/Desktop/Check-whether-characters-are-numeric/td-p/327628
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hello Nathaniel C.,
thanks for your quick reply and right answer.
For me following Formula made it the way I could work with.
=if(iserror(value('Plätze1'[ARTID]));1;0)
Sorry for late reply but just started working now and had to modify to make it suitable.
Cheers and still a nice day!!
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |