Filter by Not In State

[Anonymous]

Hi,

I wonering how I can filter for items not in a given state. Any ideas please let me know. 

Thanks

[v-hashadapu]

Hi @Anonymous , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[dufoq3]

Hi @Anonymous, what about this:

Before

After (excluded 1st floor and 2nd floor)

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUXIvyi/NS1FIy8nPL1KK1YlWcgIKGhaXIIk4A0WMUNS4AEWMi5BFXIEiJiUZSCJu2Ax3xzDcA8NwTwzDvVANjwUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, State = _t]),
    FIlteredOut1stAnd2nd = Table.SelectRows(Source, each not List.Contains({"1st floor", "2nd floor"}, [State]))
in
    FIlteredOut1stAnd2nd

[v-hashadapu]

Hi @Anonymous , could you please share more details with us to help solve your issue. If it is already solved, please share the answer here and mark it 'Accept as Solution', so others with similar queries may find it easily.
Thank you.

[v-hashadapu]

Hi @Anonymous , Please let us know if your issue is solved. If it did, please share the details here and mark it 'Accept as solution' to assist others with similar problems. If it did not, please provide further details.
Thank you.

[v-hashadapu]

Hi @Anonymous , Could you please share more details that will better discribe your issue, for us to help you solve it.

Thank you.

[Omid_Motamedise · Accepted solution]

Pkease provide the sample data for your question and explain it based on the ddata

[ZhangKun]

You should describe the problem more accurately so that we can give you more valuable suggestions.