The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to 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
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.
User | Count |
---|---|
80 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |