Forum Discussion
Summing values from second table to another
Hi, I try to create a measure, which sums up working hours in Quarters. There is a connection between two tables based on Month name & Year. Based on table 2 i want to show sum of working hours base...
Hi Anonymous ,
Here are the steps you can follow：
1. Create measure.
Measure = var _right=VALUE( RIGHT(MAX('Table2'[monthname]),4)) return CALCULATE(SUM('Table1'[Working Hours]),FILTER(ALL(Table1), 'Table1'[Year]=_right&&'Table1'[Quarters]=MAX('Table2'[Quarter])))2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
What do you mean "Based on table2"
What information is in table2, that is not already in table1?