Forum Discussion
Adding the proper column or measures
Hello, I am very new to Dax and I am trying to figure out how to properly calculate the Headcount every month using recurring employee IDs in my data set. As well trying to figure out new hires using...
Hi vjerohm
You can try to use DISTINCTCOUNT() function to calculate the Headcount every month. You can refer to the following link.
and can you provide some sample data for solving the problem?
DISTINCTCOUNT function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.