Forum Discussion

Justas4478's avatar
Justas4478
Post Prodigy
3 years ago
Solved

Filter table in Power Query to bring only for Today data

Hi, I have a fairly simple task that I am trying to do. I have multiple table in power query. But one of the table has 30mil rows of data. I do not need that many data to be pulled in to report. I ...
Need Help
  • ppm1's avatar
    ppm1
    3 years ago

    Pull the arrow down on your Date column and in Date Filters choose "Is Latest". Depending on your data source, it may "fold" back to your source and return data quickly (vs. loading all 30M rows and then filtering).

     

     

     

    Pat

     

  • Anonymous's avatar
    Anonymous
    3 years ago

    Do you know if

    = Table.SelectRows(#"Changed Type", each ([Date] = DateTime.Date(DateTime.LocalNow())))

     

    Would also work with query folding? Just thinking filter by latest would pull yesterdays results if no data was entered today?

ppm1's avatar
ppm1
Solution Sage
3 years ago

Pull the arrow down on your Date column and in Date Filters choose "Is Latest". Depending on your data source, it may "fold" back to your source and return data quickly (vs. loading all 30M rows and then filtering).

 

 

 

Pat

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Do you know if

    = Table.SelectRows(#"Changed Type", each ([Date] = DateTime.Date(DateTime.LocalNow())))

     

    Would also work with query folding? Just thinking filter by latest would pull yesterdays results if no data was entered today?

    • Justas4478's avatar
      Justas4478
      Post Prodigy
      3 years ago

      I will give it a try.

  • Justas4478's avatar
    Justas4478
    Post Prodigy
    3 years ago

    It looks like it worked.

    Is it going to filter tomorrow for tomorrows date only?