sandy666
06-10-2020, 09:25 PM
LeftRight_____LeftRightSum
2
2
2
7
7
7
3
8
3
8
11
4
9
4
9
13
10
10
10
|
5
5
5
6
11
6
11
17
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
ListSum = Table.AddColumn(Source, "Sum", each List.Sum({[Left],[Right]}))
in
ListSum
2
2
2
7
7
7
3
8
3
8
11
4
9
4
9
13
10
10
10
|
5
5
5
6
11
6
11
17
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
ListSum = Table.AddColumn(Source, "Sum", each List.Sum({[Left],[Right]}))
in
ListSum