Forum Discussion
Power Query: grouping, summing, and nulls
Let's say I have the following data in a child table: Org Score ABC 32 ABC 29 ABC 33 ABC 30 DEF 38 DEF null DEF null DEF 36 GHI null GHI null GHI null...
Hi Anonymous,
Firstly, add a custom column using the following code in your table.
= if [Score] is null then "error" else [Score]
Secondly, use “Group by” feature to calculate the scores.
Thanks,
Lydia Zhang
Something that might help get you there, try sorting your Score column and then using a GroupKind.Local in your Table.Group function. This will return local groups and you will get nulls back from your Table.Group statement. You'll have to do some cleanup but this might get you close enough to what you want to get to a solution.