DAX QUESTION!
In my source tables I have the columns Customers, StartDate, EndDate.
In the report/pivot, I want to be able to filter on a single date and capture the count of Customers where this filtered date is between the Customer Start/End dates.
The purpose is to be able see Customer count trends over time, by Year, Month and day.