Power BI Remove Rows

[rkrt1]

Hello Dear Fellows

1. I have a dataset of 6500 rows.
2. Required to keep only rows where "Function (Label)" = IT (not via filter option)
3. The source data file is weekly updated having the same structure

Required:
I am looking for a way to delete all those rows (point 2) using a function/formula so that every time when the source data file is updated, the transformation steps happen and I get the final data (rows with "IT" only).

Please help.

Cheers

 

[Kerryx]

Something like this

#"Removed IT Rows" = Table.SelectRows(#"Changed Type", each not List.IsEmpty(List.RemoveMatchingItems({[Column2]}, {"IT"})))
in
    #"Removed IT Rows"

 

[Kerryx]

Obviously rename [column 2] to [Function (Label)]in the formula

 

[rkrt1]

Something like this
View attachment 77068

#"Removed IT Rows" = Table.SelectRows(#"Changed Type", each not List.IsEmpty(List.RemoveMatchingItems({[Column2]}, {"IT"})))
in
    #"Removed IT Rows"

Hi @Kerryx

Thanks for the reply.
I tried both ways but its not working

Via M-Code:

Via Function in Applied Steps:

Can you pls help.
Thank you

 

[rkrt1]

Something like this
View attachment 77068

#"Removed IT Rows" = Table.SelectRows(#"Changed Type", each not List.IsEmpty(List.RemoveMatchingItems({[Column2]}, {"IT"})))
in
    #"Removed IT Rows"

@Kerryx
Secondly, requirement is to keep only "IT" rows and delete all other rows

 

[Kerryx]

Would this work for you

#"Grouped Rows" = Table.Group(#"Changed Type1", {"Function (Label)"}, {{"Count", each _, type table [#"Function ( externalCode)"=nullable number, #"Function (Label)"=nullable text]}}),
    IT = #"Grouped Rows"{[#"Function (Label)"="IT"]}[Count]
in
    IT