How can we limit the rows by date column using Power Query Advanced Editor?

[ironboy0418]

I have more than 1 million rows of data and the objective is to limit it only for the past 2 years. Is it possible to do it in Power Query Advanced editor?

[FreemanZ]

hi @ironboy0418 

you can filter the column

[ironboy0418]

thanks @FreemanZ 🙂 Is there a way to filter it by using Power Query M Language? My objective is to filter only the data for the past 2 years. Ex. Date>= January 1, 2022 and Date <= Yesterday?

[FreemanZ]

hi @ironboy0418 

= Table.SelectRows(#"Filtered Rows4", each Date.IsInPreviousNYears([Date], 2))

[ironboy0418]

Thanks for this! @FreemanZ However, it returns only the year 2022:

[ironboy0418]

Saw this @FreemanZ but I'm getting error incorporating it in your formula above:

[FreemanZ]

hi @ironboy0418 

do you have data older than 2 year?

vast majority of the processing in Power Query is done with mouse clicks, why bother writing code?

[ironboy0418]

@FreemanZ yup however I can't even return the data for 2023 by using date filters in columns