Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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