filter based on comparison of the columns

[amien]

If i have two fields : X and Y. Both integer.

I can filter one of them with the filter option. But what if would like to filter on this : WHERE X > Y

how can i do this? I would like to do this in M. And without creating a new column with the difference between X and Y, and filter on this.

Thanks in advanced.

[MattAllington]

When you say 2 fields, do you mean 2 columns?  If you want to do this in Power Query (M as you say), then you will need a new column. But it doesn't have to be the difference between the 2 columns. Just add a new column something like this. 

if [X] > [Y] then 1 else 0

then just filter when this column equals 1. 

[OwenAuger]

Hi there,

If you want to avoid adding a column as an intermediate step, you could also use a logical expression to filter based on multiple columns such as:

= Table.SelectRows(OriginalTable , each [X] > [Y] )