Use a filter to identify all months with dates inbetween a date range

[stevedata]

I have a date range column and alongside this I have created copy columns splitting it to have a start date column and and end date column.

I want to select a month from the calendar as a filter so that my data shows data lines within a range than includes the month i would have selected - even when that month is not the start month or the end month.

For example:

Line 1 - start date: 12/01/2023 with end date: 03/03/2023

Line 2 - start date: 14/04/2023 with end date 23/07/2023

Using a month filter - I want to be able to select e.g. 'June 2023', then line 2 above should show as the result since the range is from April to July 2023, or if i select February 2023 then line 1 should show in the result since the range is January 2023 to March 2023.

thanks for your help in advance

[stevedata]

wow! that worked a charm. Incredible stuff. thank you.

[stevedata]

anyone with a clue? any help appreciated.

[Anonymous · Accepted solution]

Hi @stevedata ,

Create an unconnected table for the slicer and use the visual filter. Please refer to the attachment.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum