Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a column with data where I need to filter out lines with specific phrases and have found that the Conditional Column is not returning the results I would expect.
The column it's drawing from is in Text format, and contains information such as:
123test.Phrase.OtherText
Now that Phrase part could also appear in other parts of the text, but here it is nested by two dots, so I tried using a conditional column with this criteria:
If Column contains .Phrase. result is X. Only it's not picking it up.
If I manually filter on the query level to check, I can filter out the lines with .Phrase. but the Conditional Column tool doesn't recognize it and just returns null.
Any ideas?
PS: I'm not trying to filter out this data by itself, so filtering it out on query level wouldn't be a solution. I need to mark it as separate.
Solved! Go to Solution.
Hi,
can you use power query and do this in a custom column prior to a calculated column?
if so try:
if Text.Contains([Text Field],".Phrase.") then "X" else "Y"
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Additionally if you need to use DAX you could create a calculated column with the below:
Hi,
can you use power query and do this in a custom column prior to a calculated column?
if so try:
if Text.Contains([Text Field],".Phrase.") then "X" else "Y"
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Gives a Y answer for the lines that should be flagged X, unfortunately.
That's odd, seemes to be working for my tests:
do you have some other example data that it's not working on?
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Update: I just tried with case sensitive options, and it worked!
User | Count |
---|---|
84 | |
76 | |
64 | |
51 | |
46 |
User | Count |
---|---|
101 | |
42 | |
41 | |
39 | |
36 |