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.
Dear all,
I would like to define roles, but unfortunately I do not know the needed expression.
I do have a column “PLP”, containing several correct entries, but sometimes it is just mentioned “not defined” or the line is empty.
Now I would like to exclude the empty ones as well as the ones stating “not defined”…
I already have several roles in place, but these do never exclude something, but just search for something specific.
Is there anybody out there who could help me, please?
@Orstenpowers , Not very clear. In edit query mode you can replace null value with other values
https://www.howtoexcel.org/power-query/bulk-replace-values/
Hi @Orstenpowers ,
Not very clear.
What is the expected output. A table, a column.
You can use the EXCEPT function
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi, I am trying to define/ manage roles
I thought of something like
[PLP] <> "not defined" && [PLP] <> blank
but this does not work.
How do I need to adjust this to work properly? Can you help me?
I got it on my own. 🙂
[PLP] <> BLANK() &&
[PLP] <> "not defined"
Thanks for your offered support!
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |