Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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_Daniel's avatar
    wdx223_Daniel
    Community Champion

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Perfect many thanks