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...
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
Shaurya
Memorable Member
Memorable MemberHi 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
Thank you! Don't know how I didn't think of that.