Forum Discussion

Tsanka's avatar
Tsanka
Icon for Kudo Collector rankKudo Collector
11 years ago
Solved

Define aggregation behaviour of columns

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

 

 

  • Anonymous's avatar
    Anonymous
    11 years ago

    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.

     

    Capture.JPG

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

     

    Capture.JPG

    • Tsanka's avatar
      Tsanka
      Icon for Kudo Collector rankKudo Collector

      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.