passing date value to a filter in Power Query

Question

Hi can anybody help with this please:&nbsp;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?&nbsp;Many thanks&nbsp;Nick&nbsp;

wdx223_daniel · Accepted Answer

=Table.SelectRows(DailyOrderTable,each [Date]&gt;=OneRowTable[StartDate]{0} and [Date]&lt;=OneRowTable[EndDate]{0})

Forum Discussion

Related content

Passing filter selected value to paramater

Passing filter selections to bookmarks

Fabric passing parameter

Passing SecureString Parameter Values in notebooks

VBA support (to pass cell value as a dax filter) needed to pull data from power bi to excel