Creating team specific reports in Power BI

Hi RichardLBHF1 ,

You can achieve the desired output by using a disconnected calendar table and writing a DAX formula like the one below to calculate headcount over different time periods for employees in a particular team.

Headcount =
SUMX (
    EmployeeFact,
    IF (
        EmployeeFact[Start] <= [SelectedDate]
            && EmployeeFact[End] >= [SelectedDate],
        1,
        BLANK ()
    )
)

The key to creating a dynamic headcount analysis is to use a disconnected calendar table. I've attached a link to an article that discusses this topic.

https://community.fabric.microsoft.com/t5/Community-Blog/Dynamic-Headcount-Analysis-using-Dax/ba-p/4164529

I've also attached an example pbix file.

Best regards,