Forum Discussion
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:
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?
Hi Anonymous,
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
2 Replies
- Shaurya
Memorable Member
Hi Anonymous,
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