Calculate the count of customers between two dates.

[Anonymous]

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?

Regards

[amitchandak · Accepted solution]

@Anonymous , Refer if my blog on similar topic can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[amitchandak · Accepted solution]

@Anonymous , Refer if my blog on similar topic can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

[Anonymous]

@amitchandak 

Thank you for your reply. can I use Countx and Distinct on the expression?
I want to count distinct customers between two dates.

[Anonymous · Accepted solution]

To count distinct values, I used the expression below, and it works fine.

Current = CALCULATE([Count of customers],(FILTER(Table,Table[StartDate] < max('Date'[Date]) && (Table[EndDate] > max('Date'[Date])))))