Forum Discussion

vadepu's avatar
vadepu
Frequent Visitor
5 years ago
Solved

Add two columns values from different tables

Hi ,    Need help !!   I have below tables Table 1:   Table 2:   Table 3:   Note: Score column is based on some condition pn Age column in all the tables. Example: sco...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  vadepu ,

    Here are the steps you can follow：

    1. Create calculated table.

    calculatedtable1 =
var _1=SUMMARIZE('Table1',[Brand],"Score",MIN('Table1'[Score]))
var _2=SUMMARIZE('Table2',[Brand],"Score",MIN('Table2'[Score]))
var _3=SUMMARIZE('Table3',[Brand],"Score",MIN('Table3'[Score]))
var _union=UNION(_1,_2,_3)
return
_union
    calculatedtable2 =
SUMMARIZE('calculatedtable1',[Brand],"Score",SUM('calculatedtable1'[Score]))

    2. Create calculated column.

    Car = RANKX('calculatedtable2','calculatedtable2'[Brand],,ASC)

    3. 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
5 years ago

Hi  vadepu ,

Here are the steps you can follow：

1. Create calculated table.

calculatedtable1 =
var _1=SUMMARIZE('Table1',[Brand],"Score",MIN('Table1'[Score]))
var _2=SUMMARIZE('Table2',[Brand],"Score",MIN('Table2'[Score]))
var _3=SUMMARIZE('Table3',[Brand],"Score",MIN('Table3'[Score]))
var _union=UNION(_1,_2,_3)
return
_union
calculatedtable2 =
SUMMARIZE('calculatedtable1',[Brand],"Score",SUM('calculatedtable1'[Score]))

2. Create calculated column.

Car = RANKX('calculatedtable2','calculatedtable2'[Brand],,ASC)

3. 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