Adding the proper column or measures

[vjerohm]

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 MIN using the date to see when their Employee ID starts to show up and MAX function to see when it is last seen. I am very new to Power BI and DAX so I have been having a hard time figuring out how to do anything.

All relevant info that my data sets give me is employee ID and each data file is attached the month and year that the data was gathered.

Please any tips or suggestion is deeply appreciated! Thank you very much

[Anonymous]

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.