Forum Discussion
Calculating Vacation Day Ratio
EDIT: I've explained this a bit more thoroughly in a comment below. I've been struggling with this on my own for a bit, if someone could find a solution you would make my year! I have two sets of d...
There you go:
I created a new measure
Vacation Days_Used = COUNT(Vacation_Days_Tb[Vacation Day])So from previously instead of getting from the column value i get the new ratio from this measure /thats the wonders of measures, it lets you built up your solution block by block:
For the Headcount i plug in the values as previosly, to calculate it from your employee table you just have to follow the solution at :
https://community.powerbi.com/t5/Desktop/Number-of-employee-between-two-dates/m-p/398921#M182124
For understanding, i proposed you attempt your solution one table/one measure at a time and if you hit specific question we are here
Regards
YJ
Resolver II
Resolver IIHi,
can i ask what is the link between the Sick day under vacationdays taken table and Vacation days used under vacation and headcount table?
regards
Sorry for the confusion, it's supposed to be vacation. I'm starting with vacation and would like to move to sick days after to create an all absences rate.