topic Re: Table in Query editor in Power Query

Table in Query editor

jagtaps — Thu, 03 Mar 2022 21:44:06 GMT

Hello,

I have a table containing the Cost Types which are repeating for 12 rows (representing 12 months data), i have per month cost update in uploaded data.

Can you add column in table and cumulate the costs based on cost types??

Regards,

Re: Table in Query editor

PhilipTreacy — Fri, 04 Mar 2022 01:51:54 GMT

Hi jagtaps

Sounds like you want to Group the Cost Types and sum the costs in the months column.

Please supply some sample data as a text file/table (copy and paste here) or supply your file.

Regards

Phil

Re: Table in Query editor

v-jingzhang — Tue, 08 Mar 2022 07:10:59 GMT

Hi jagtaps

Your expected output is not clear to me. If your data is similar to below and you want to get the total cost per cost type, you can group by Type column and calculate the sum of Cost column.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.