Filter table in Power Query to bring only for Today data

[Justas4478]

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 · Accepted solution]

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

[ppm1 · Accepted solution]

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

[JamesRobson · Accepted solution]

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]

I will give it a try.

[Justas4478]

It looks like it worked.

Is it going to filter tomorrow for tomorrows date only?