topic Re: Delete rows based on conditions in DAX Commands and Tips

Delete rows based on conditions

Learner86 — Tue, 31 Aug 2021 09:55:52 GMT

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!

Re: Delete rows based on conditions

Learner86 — Tue, 31 Aug 2021 10:00:20 GMT

My problem addresses the following table:

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

Re: Delete rows based on conditions

Tanushree_Kapse — Tue, 31 Aug 2021 10:17:56 GMT

Learner86 ,

All your frequencies are bigger than 1

Re: Delete rows based on conditions

Fowmy — Tue, 31 Aug 2021 10:29:37 GMT

Learner86

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

Re: Delete rows based on conditions

Samarth_18 — Tue, 31 Aug 2021 10:40:51 GMT

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

Re: Delete rows based on conditions

Learner86 — Tue, 31 Aug 2021 13:38:01 GMT

Samarth_18: Thank you very much for the solution.

Re: Delete rows based on conditions

Samarth_18 — Tue, 31 Aug 2021 13:49:51 GMT

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