Define aggregation behaviour of columns

[Tsanka]

Spoiled by the features in Excel PowerPivot, I am looking how to define aggregation behavior of the columns ("Summarized By" in PowerPivot).

Is this possible in PBI desktop?

To achieve this I am forced to create measures for all columns for which the aggregation is to be different from sum.

Thanks

[Seth_C_Bauer · Accepted solution]

Hey Tsanka,

There is limited ability to do some aggregations.

After you start a report part, you can click on the down arrow under the "Values" section on one of the columns you are using and you have options. Not a specific Summarize by column..., but it is most likely where they would include the feature.

[Tsanka]

Thanks so much, Eno1978.

This is exactly what I was looking for (however I search for it in the query editor not in the report parts). Thanks once again.