Forum Discussion

ironboy0418's avatar
ironboy0418
Helper II
3 years ago

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?
ironboy0418's avatar
ironboy0418
Helper II
3 years ago

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's avatar
FreemanZ
Super User
3 years ago

hi ironboy0418 

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

  • ironboy0418's avatar
    ironboy0418
    Helper II
    3 years ago

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

     

    • ironboy0418's avatar
      ironboy0418
      Helper II
      3 years ago

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

       

      • FreemanZ's avatar
        FreemanZ
        Super User
        3 years ago

        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?