Forum Discussion
ironboy0418
3 years agoHelper II
How can we limit the rows by date column using Power Query Advanced Editor?
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
3 years agoSuper User
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
3 years agoHelper II
FreemanZ yup however I can't even return the data for 2023 by using date filters in columns