Delete rows based on conditions

[Learner86]

Dear community,

how can delete rows based on conditions? I need something like this: if the costs are smaller then 3800 and if the frequency is bigger 1 and the Mdt ist unequal 30 then delete the rows. How can I do this?

Unfortunately, I can't add a table to this post bacause I get the message "marked as spam". I tried different thing but it doesn't work.

Many thanks for your help!

[Samarth_18]

Hi @Learner86 

You can create a custom column in trasform data tab with below code:-

if [costs] < 3800  and [Frequency] > 1 and  [mdt] <> 30 then 1 else 0

Now filter your custom column of table by selecting "0" 

and then click on "close and apply"

You will see your desired result.

Thanks,

Samarth

[Learner86 · Accepted solution]

@Samarth_18: Thank you very much for the solution.

[Samarth_18]

Great! @Learner86  it helps you. Kindly accept my answer as solution so that people can find it more quickly.

[Learner86]

My problem addresses the following table:

I want to delete the rows 1,3 and 5.

[Fowmy]

@Learner86 

You can apply filters in Power Query to get the desired results. 

[Tanushree_Kapse]

@Learner86 ,

All your frequencies are bigger than 1