Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Orstenpowers
Post Patron
Post Patron

Exclude expressions for defining a role

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?

4 REPLIES 4
amitchandak
Super User
Super User

@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/

harshnathani
Community Champion
Community Champion

Hi @Orstenpowers ,

 

Not very clear.

 

What is the expected output. A table, a column.

 

You can use  the EXCEPT function 

 

https://dax.guide/except/

 

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

 

Unbenannt.JPG

 

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.