Delete Rows with condition

[tee_tt]

Hi,
I have a table that looks like this:

country	province	cp	weather	area	cp_year	yield
AA	adea	maiz	winter	1	2007	1
BB	kakaki	flower	sunny	30000	2000	50000
CC	zuru	eggs	autum	0	2010	1

I want to delete all rows with area and yield less than 1

how do i implement this? am very new with PBI

NB: The table have more than 5,000 observation and i have already loaded the data in PBI.

Regards

[PaulDBrown · Accepted solution]

In Power Query, select the column and set a filter (the dropdown arrow in the column header) to exclude the values you don't need.

[PaulDBrown]

Do you want to delete the rows so they don't get loaded into the model or do you need to delete them for some visuals in the report?

[tee_tt]

@PaulDBrown , I dont need them in my model. I want to totally delete them

[tee_tt]

i mean <= 1