Forum Discussion

Domenick's avatar
Domenick
Icon for Helper IV rankHelper IV
6 years ago

[Help!] Comparing Expected Hours Table to Time Log

I want to display a matrix of available hours per day for each employee that can roll up into week & month. I have a table of hours that are logged by project and day (so each day might have multiple...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Domenick 

With the relationships below

Create measures in Planned Hours table,

measure_Hours Per Day = SUM('Employee Details'[Expected Hours Per Day])

planned hours = SUM('Planned Hours'[Hours])

result = SUMX('date',[sub])

 

To fill the blank cell with values need more transformations, i will update it later.

Please first check if my first reply solve your problem partly.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.