Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
=Table.SelectRows(DailyOrderTable,each [Date]>=OneRowTable[StartDate]{0} and [Date]<=OneRowTable[EndDate]{0})
=Table.SelectRows(DailyOrderTable,each [Date]>=OneRowTable[StartDate]{0} and [Date]<=OneRowTable[EndDate]{0})
Perfect many thanks