Calculate the count of customers between two dates.
I have two date columns, StartDate, and Enddate. What I wanted to do is whenever I select a date from the filter, I want to get the calculated value of the count of customers where StartDate < selected date > EndDate.
How can I calculate the count of customers between two dates? Do I have to create a calendar table to use the date as a filter? If yes, Power BI allows only one active relationship, so how can I connect the date table with the two date columns StartDate and EndDate with the fact table?