How to create custom column in power BI for calculated column

[shubhankar]

I want to create column Total leaves in table 2 as given below plese help

Table 1

Name      Leaves      ID

name1          2           1

name2          1           2

name1          1           1

name3          1           3

name1          0           1

name2          2           2

Table 2

Employee     Employee Id      Total leaves

name1                1                        3

name2                 2                       3

name3                3                        1

[Zubair_Muhammad · Accepted solution]

@shubhankar

If the 2 tables are related you can add this calculated column in Table 2

Total Leaves =
CALCULATE ( SUM ( Table1[Leaves] ) )

[shubhankar]

It works Thanks