PowerBI GUI vs Advanced editor
Filtering rows:
Grouping:
#"Grouped Rows" = Table.Group(#"Changed Type", {"State"}, {{"c_Pofit_by_state", each List.Sum([Profit]), type nullable number}})
Note: this is pretty slow when doing it from the editor, gui pivot is much faster.
