Forum Discussion

Learner86's avatar
Learner86
Icon for Helper I rankHelper I
5 years ago
Solved

Delete rows based on conditions

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...
  • Learner86's avatar
    Learner86
    5 years ago

    Samarth_18: Thank you very much for the solution.

Learner86's avatar
Learner86
Icon for Helper I rankHelper I
5 years ago

My problem addresses the following table:

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

  • Tanushree_Kapse's avatar
    Tanushree_Kapse
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Learner86 ,

     

    All your frequencies are bigger than 1

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    5 years ago

    Learner86 

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