I searched but could not find a situation like mine.
I have two columns with dates, one is the date of the registration on a course, and the other is the expiration date of that license.
So i need to find if a selected date or interval is between the two dates, so i can find all those who are/were with a active registration on that period.
In the slicer, If i select 25/03/2023 and 28/03/2023 it should show the seven entries with udemy but not any alura, because the interval is between the registration and expiration date of the udemy, but not enough for the alura to get active.
if i select 23/03/2023 and 30/03/2023 it is going to show all entries, because the period is between the dates in both columns.
if i select 05/05/2023 and 30/06/2023 it is going to show the seven entries again, because its after the expiration of the alura license, but the udemy period is active between the dates.
Thanks in advance!