Filtering based on date from another table

[LFischl]

Hello,

I have 2 tables.

The first table has a list of network changes which includes planned start date, planned end date, and the configuration items that the change will impact.

The second table has a list of all of the incidents created by our customers, this table includes the configuration item impacted and the date the incident was created.

I'd like to build a report that shows me all the incidents that were created for a configuration item within 24 hours of the planned start date of the change.

I don't know how to filter the incidents to only show the ones that were created with 24 hours after the planned start date.

Thank you,

[parry2k]

@LFischl could you please share the sample data with the expected output to provide the solution? If possible share pBIX using 1/g drive and remove sensitive information before sharing.

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[LFischl]

This would be an example of the data from the tables

I have no problem pulling together a list of all the changes that caused an incident for circuit A for example, but I'd like to be able to see the incidents that were created within 12 hours of the close of the change.

Ticket Number	Circuit Number	Ticket Created Date	Ticket Closed Date
inc1001	Circuit A	08/30/2022	09/01/2022
inc1002	Circuit B	09/01/2022	09/05/2022
inc1003	Circuit A	09/05/2022	09/07/2022

Change Number	Impacted Circuit	Change Start Date	Change End Date
CHG001	Circuit A	08/29/2022	08/29/2022
CHG002	Circuit B	08/30/2022	08/30/2022
CHG003	Circuit A	09/05/2022	09/05/2022