Forum Discussion
Anonymous
5 years agoNot applicable
passing date value to a filter in Power Query
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
=Table.SelectRows(DailyOrderTable,each [Date]>=OneRowTable[StartDate]{0} and [Date]<=OneRowTable[EndDate]{0})
2 Replies
- wdx223_DanielCommunity Champion
=Table.SelectRows(DailyOrderTable,each [Date]>=OneRowTable[StartDate]{0} and [Date]<=OneRowTable[EndDate]{0})
- AnonymousNot applicable
Perfect many thanks