Skip to main content

Power BI

New

Specify default aggregation for a column in Power Query table type metadata

Vote (5) Share
Stanislaw Swierc's profile image

Stanislaw Swierc on 29 Jun 2017 00:27:28

I'm working on the custom extension. In our dataset there are columns for which "average" is the only aggregation that makes sense. However in Power BI Desktop all numeric columns get "sum" as a default aggregation. Can this be overridden from Power Query (e.g. type metadata)?

https://stackoverflow.com/questions/44703390/is-it-possible-to-override-default-aggregation-for-a-column-from-power-query/44765311#44765311