group by variable column name

[Sammy_home]

Hi all,

I try to achieve a report with a 'group by' which uses flexible column names.

The column names are handed over from another table which is filled with a different manual edited name, every time i run the report differently. In my example it is "Testname"

The datatable has a basic headline (in my example it is "Value") and is renamed within the query with the parametername from above.

But I got stuck at the point where I want to group my data table with a sum of my renamed column as it requires a flexible name.

Below you can find a screenshot of the query and in the second screenshot I highlighted the field which should actually be filled with the parametername as fieldname.

Maybe I'm stupid but currently I can't find a way out to achieve that.

Every help is appreciated. Thanks!

Regards,

Sammy

[wdx223_Daniel · Accepted solution]

List.Sum(Table.Column(_,#"para_name"))

[v-yalanwu-msft]

Hi, @Sammy_home ;

I'm a little confused, are you trying to dynamically sum Testname? Is testname from another table? Can you provide a simple file and a display of the results you wish to output?

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.

[Sammy_home]

@wdx223_Daniel perfect thanks!!!
It is exactly what I've been trying to achieve.

The output looks now like following to reply to you question @v-yalanwu-msft