Filter rows with date in one table using 2 other dates from not-related table

[sandra_p]

I have in table Sprint defined 2 columns - on one is start date and the other is end date.

In other table Worklogs - I have a worklog date column.

There is no direct relationship between tables (but, there is a third table, which has a relationship with each of the tables named above - through the same column, this third table is linked to both tables via Task ID column)

Using Drill-through - in target page I want automatically filter all worklogs, that are made within Sprint start and end date.

Can't find, how to do that (I am a beginner in Power BI).

[v-diye-msft]

Hi @sandra_p 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[sandra_p]

Hello,

Unfortunatelly, it is not possible.

To better show idea, here are dummy example tables modeled in Excel:

This is a table that contains start and end dates of sprints.

This table contains all worklogs:

I want to filter all worklogs, that are in the time period of sprint start and end date - so that, when I filter based on Sprint name, report shows all worklogs in that time period.

Is that possible?

Thanks!

[amitchandak]

Refer, if this can help

https://docs.microsoft.com/en-us/dax/treatas-function

[sandra_p]

Thank you for answer.

Can you please elaborate? What do I need to create - is it new measure, new column? 

My idea is, that it would be good, if I could define in some filter, that start date and and date is from Sprints table, but filters all records from Worklogs table that fall within start and end date.