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:

       

      • FreemanZ's avatar
        FreemanZ
        Icon for Super User rankSuper 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?