Forum Discussion
Evaluate Headcount Table (SCD type II) for Trending Headcount
Hi Team, Here's a snippet of three tables I have, one is a basic calendar table, with date, endofweek, and endofmonth and the second on is a employee table that's a slow changing dimension type ...
powerbiexpert22
Impactful Individual
Impactful IndividualHi Anonymous ,
please try below , please see below pbix for your reference
https://drive.google.com/file/d/1HVSc9j7yGE1vVXxvZBNf2HpFaeQrTi4z/view?usp=drive_link
Trending Headcount =
CALCULATE(
COUNTROWS(employee),FILTER(ALLEXCEPT(employee,employee[endofmonthemp]),
employee[eff_tmstp]<=max(employee[endofmonthemp]) && employee[emp_status]="active"))