Forum Discussion

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 only rows that have todays date.

Does anyone know how I can filter that table. I cant find anything that would work in the toolbar.

Thanks.

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
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?

4 Replies

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
  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
    Post Prodigy
    3 years ago
    I will give it a try.
- Justas4478
  Post Prodigy
  3 years ago
  It looks like it worked.
  Is it going to filter tomorrow for tomorrows date only?

Related content