Forum Discussion

PietroP's avatar
PietroP
New Member
4 years ago
Solved

Wrong column total relationing two tables

Hi everyone, i have two tables:   table1: SiteCode, Work_ID, Date_Of_Work   ex: work_ID SiteCode date_of_work 2021CF000030 D03125 11/03/2021 00:00 2019CF000017 D00019 19/09/20...
  • Anonymous's avatar
    Anonymous
    4 years ago

    PietroP 

    You may just create a column in Table 1 to get the TOTKW from table2, this should be more clear to you.

    TOTKW = Related(table2[TOTKW])

     

    Then you can just create measure or column with simply sum.
    measure = sum(table1[TOTKW])

     

     

    Best regards
    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

PietroP 

You may just create a column in Table 1 to get the TOTKW from table2, this should be more clear to you.

TOTKW = Related(table2[TOTKW])

 

Then you can just create measure or column with simply sum.
measure = sum(table1[TOTKW])

 

 

Best regards
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.