Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
NataliaG
Regular Visitor

Grouping on multiple columns and appending query

Hi, I have a table that I'm grouping by 3 columns Name1, Name2, and Name3 and I create 3 new columns Name1Avg, Name2Avg, and Name3Avg. As in the screenshot below:

NataliaG_0-1671558475242.png

 

As a result of grouping, I would like to get only column Name and AvgTime:

NataliaG_1-1671558643202.png

Is there a way to achieve this? Is it possible e.g. to append a table with the result of such grouping only to column Name and AvgTime?

1 ACCEPTED SOLUTION
Shaurya
Memorable Member
Memorable Member

Hi @NataliaG,

 

Create three different tables for Name1, Name2 and Name3 with their respective average column by using SUMMARIZE.

 

Table 1 = SUMMARIZE('Table','Table'[Name1],"Average",AVERAGE('Table'[Value]))

 

Similarly create Table 2 and 3 and then use UNION.

 

Result Table = UNION(Table 1, Table 2, Table 3)

 

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

View solution in original post

2 REPLIES 2
Shaurya
Memorable Member
Memorable Member

Hi @NataliaG,

 

Create three different tables for Name1, Name2 and Name3 with their respective average column by using SUMMARIZE.

 

Table 1 = SUMMARIZE('Table','Table'[Name1],"Average",AVERAGE('Table'[Value]))

 

Similarly create Table 2 and 3 and then use UNION.

 

Result Table = UNION(Table 1, Table 2, Table 3)

 

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

Thank you! Don't know how I didn't think of that.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.