Add different rows

[Syndicate_Admin]

I have a mother table that joins me all the tables I have but when I do the sum of the columns I skip the total value in all the rows instead of the value by the name of each row. How can I do?

[v-yalanwu-msft]

Hi, @Syndicate_Admin ;

Sorry, I don't quite understand what you mean. Could you give a simple example and the result you want to output? To make it easier to understand your logic. Maybe with unpivot

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HenriqueReis]

HI,

You can merge those consults in Power Query here:

 so all the date will be in the same column and the SUM will give you the result you want.