Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Withanic_101
Frequent Visitor

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

 

1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

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

View solution in original post

2 REPLIES 2
wdx223_Daniel
Super User
Super User

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

Perfect many thanks

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors