Forum Discussion
Helper IConvert a Column of Tables (After Merge Query Step) to a Column of list
Community ChampionHello Hashiru
don't get the connection with your initial request 🙂
However... `here a few questions
- is the other data in the table needed? Or do you need only to get the sum of if
- in case you need the whole table, where do you want to have the sum? In a new column in your main table?
Merry christmas also to you
Jimmy
Helper IHi Jimmy801,
The whole table is needed and I am required to sum two columns. I will like to have the sum on a new column in the sub table, this way I can expand the required columns my analysis needed
Thanks
- Jimmy801
Hello Hashiru
I don't know the second colum 🙂
but to sum the OU Num-Column of the sub-table Time and Labour add a new column (select the symbol in the program) and past in this code. This should do the trick
List.Sum([#"Time & Labour"][#"OU Num"])
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy