passing date value to a filter in Power Query

[Withanic_101]

Hi can anybody help with this please:

From a live Oracle date table I have created a table with one row creating a start date and an end date for the latest reporting week. I have another table that holds daily orders, I want to use the start and end date from my one row table to change the dates filter in the order table, so when I refresh each week I only get the correct reporting weeks data?

Many thanks

Nick

[wdx223_Daniel · Accepted solution]

=Table.SelectRows(DailyOrderTable,each [Date]>=OneRowTable[StartDate]{0} and [Date]<=OneRowTable[EndDate]{0})

[Withanic_101]

Perfect many thanks