Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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