Forum Discussion
Measure for Average Head Count
Hello this is only my 2nd time posting to the forum. I need assistance with some DAX measures so that I can determine Turnover % for an HR Power BI I have been tasked to complete. I have managed to...
vapid128
Solution Specialist
Solution SpecialistOK , I SEE THIS FOR ALL DAYS , AND NO ONE ANSWER.
Creating only a measure is not a good idea for this case.
Creating another table would make it work.
Table22 = GENERATE('HR Date Range',GENERATESERIES(int('HR Date Range'[Hire_Date]),int('HR Date Range'[TermDate])-1))
It will have a new colnum "value", it is your date colnum.
your HC will be measure
HC=DISTINCTCOUNT(table22[StaffID])