Forum Discussion
Solved
Calculate Hours
Hey guys, I'm working on a new rapport and my issue is with calculating the hours spend on a project I have 2 tables and in one of them is the complete registration of Hours and I have another t...
Hi RonaldvdH ,
It seems that Table1 and Table2 are connected through ProjectCode column. If yes, You just need to create the calculated column below:
Column = CALCULATE ( SUM ( Table2[Hours] ), FILTER ( RELATEDTABLE ( Table2 ), Table2[Week] = Table1[Week] ) )If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.
Regards,
Loran
Hi RonaldvdH ,
It seems that Table1 and Table2 are connected through ProjectCode column. If yes, You just need to create the calculated column below:
Column =
CALCULATE (
SUM ( Table2[Hours] ),
FILTER ( RELATEDTABLE ( Table2 ), Table2[Week] = Table1[Week] )
)
If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.
Regards,
Loran