Delete every 2nd row in Power BI

[mafioso]

Is it possible to delete every second row of my dataset? Every second row is a blank one so i want to delete it. 

[ImkeF]

You can use the function Table.AlternateRows for it like so:

Table.AlternateRows(Source,1,1,1)

This would keep the first row of table "Source" and delete the second, take the 3rd and continue to delete all even rows.

[vanessafvg]

@mafioso  just say remove empty from the drop down arrow on the column

[mafioso]

Ok thank you! Moreover, is it possible to remove the rows with a certain value in a column? 

I want to remove every row which contains "null" or "0" in the hours column.

Thanks for your help!

[vanessafvg]

@mafioso  you can easily filter out columns with those values just use the drop down arrow again on the column and there will be a filter option, you can untick all the values you not intersted in

[mafioso]

Yes I know that I can filter them but I don't need them anymore and that's why I think deleting them it is more efficient.

[vanessafvg]

@mafioso so you want to delete the value and keep the row or filter out the row based on the value?

you can't delete it physically from your source file, you can only apply steps that will remove it from the dataset you end up with, filtering out the values you dont want is removing it from the dataset.

[mafioso]

@vanessafvg I want to do it the way I used to remove the empty rows. If a column contains a certain value I want to remove the row from the dataset. Or doesn't it make any difference if I use the filter? I am new in Power BI and that's why I'm not definitely sure. 

[vanessafvg · Accepted solution]

@mafioso no problem, removing the empty rows is the same thing filtering them out based on the condition they empty, so as per my first response on the top of the column in query editor, the drop down arrow on the column select  remove empty, that will remove all empty rows from the dataset, where that column is empty, for anything other values you can also use the filter which is located in the same drop down as remove empty, and then also filter out any other values you dont want in the filter section?  make sense?

[mafioso]

@vanessafvg yes, thank you very much for your help!