Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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
Solved! Go to Solution.
If the 2 tables are related you can add this calculated column in Table 2
Total Leaves = CALCULATE ( SUM ( Table1[Leaves] ) )
If the 2 tables are related you can add this calculated column in Table 2
Total Leaves = CALCULATE ( SUM ( Table1[Leaves] ) )
It works Thanks