Skip to main content

    Power BI

    Needs Votes

    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