Need help to filter down a table based on date fields on another table

[EaglesTony]

Hi,

  I need help in Power BI M query to filter down a 2nd table based on the 1st table dates.

1st table (only will have one row):

tbl1StartDate: 1/31/2024

tbl1EndDate:  2/13/2024

2nd table:

Item1

tbl2StartDate: 1/17/2024

tbl2EndDate:  1/30/2024

Item2

tbl2StartDate: 1/31/2024

tbl2EndDate: 2/13/2024

Item3

tbl2StartDate: 1/31/2024

tbl2EndDate: 2/13/2024

In the above scenerio, I want to filter table2 to only have Item2 and Item3 and NOT contain Item1

[amitchandak · Accepted solution]

@EaglesTony , Just add any filter on date using the filter option on column down arrow

and then later go and replace those date with

List.Min(Table1[Date]) 

List.Max(Table1[Date])

Use these in place of date selected in filter