Forum Discussion
Count based on date compared to two fields in another table
Something like this?
No of Employees =
CALCULATE (
COUNT ( employee[employee] ),
FILTER (
employee,
AND (
employee[hire date] <= 'week ending'[week ending],
employee[termination date] > 'week ending'[week ending]
)
)
)If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Something like this?
No of Employees =
CALCULATE (
COUNT ( employee[employee] ),
FILTER (
employee,
AND (
employee[hire date] <= 'week ending'[week ending],
employee[termination date] > 'week ending'[week ending]
)
)
)
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Thank you so much for answering my noob question. That's exactly what I was after.
==
Chris