Forum Discussion

tabuzahra's avatar
tabuzahra
Icon for Helper II rankHelper II
6 years ago

Showing Comulative Sum According To Slicer Dates

Hello, I'm seeking your support in this impressive community in the following challenge that I'm facing,   I have created a measure to calculate the standard hours for each employee accoring to th...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi tabuzahra,

You want to calculate cumulative net hours for the still working employees according to slicer dates . Right? The hours are between Termination Date and Enterprise Hire Date, and except vacation dates, weekends, holidays and Ramadan. Do I understand correctly?

Or we just need to calculate the hours between Termination Date and Enterprise Hire Date and expect vacation dates?

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.