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

Question

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 · Answer

hi&nbsp;ironboy0418&nbsp;you can filter the column&nbsp;

ironboy0418 · Answer

thanks&nbsp;FreemanZ&nbsp;🙂 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&gt;= January 1, 2022 and Date &lt;= Yesterday?

freemanz · Answer

hi&nbsp;ironboy0418&nbsp;= Table.SelectRows(#"Filtered Rows4", each Date.IsInPreviousNYears([Date], 2))

ironboy0418 · Answer

Thanks for this!&nbsp;FreemanZ&nbsp;However, it returns only the year 2022:&nbsp;

ironboy0418 · Answer

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

Forum Discussion

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

7 Replies

Related content

Advanced Editor does not apear

Advanced Editor - Filtering Columns

Advanced Editor - Add Column from Related Table

Is there any way of editing column mapping with advanced destination editor in Gen2 CICD dataflows?

Text size in Advanced Editor