Forum Discussion

ironboy0418's avatar
ironboy0418
Icon for Helper II rankHelper 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
Icon for Helper II rankHelper 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
    Icon for Super User rankSuper User
    3 years ago

    hi ironboy0418 

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

    • ironboy0418's avatar
      ironboy0418
      Icon for Helper II rankHelper II
      3 years ago

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

       

      • ironboy0418's avatar
        ironboy0418
        Icon for Helper II rankHelper II
        3 years ago

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