Grouping on multiple columns and appending query

[NataliaG]

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:

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

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?

[Shaurya · Accepted solution]

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

[NataliaG]

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