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: