Filter date based on Start Date and End Date fields of another table

[MHatMFT]

I'm building a power BI sheet to keep track of marketing campaings. The campaigns table has fields for name, start date and end date. Companies are added to the campaign via the campaign contacts table, and I'm linking to the transactions via the companies table.

What I want to do is have a slicer that chooses the campaign and shows only the transactions with a transaction date between the start date and end date of the selected campaign.

Currently I can pull through all transactions for a company that is part of a campaign, but I want to filter it down by start and end date so I can see which transactions were generated as a result of the campaign. Is there any way to set a filter for the date range and have the range change based on which campaign is selected by the slicer?

[amitchandak · Accepted solution]

@MHatMFT , check if approach of this blog or the attached file can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...