Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

Add different rows

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?

2 Replies

  • HenriqueReis's avatar
    HenriqueReis
    Resolver I
    4 years ago

    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.

     

     

     

     

     

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    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.