Community Center | Not monitored
Tag not monitored by Microsoft.
Yes, this can be done in PQ, but it's a bit convoluted. This is usually more natural to do in Excel or DAX, once the data is loaded. Would that be an option?
how to insert specific row
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 0%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jaba Archuadze
1
Reputation point
Is it possible to add a row in the table that summarizes all the rows above it? [1]: /api/attachments/79231-capture.png?platform=QnA [2]: /api/attachments/79120-result.png?platform=QnA
Community Center | Not monitored
1 answer
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 31%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
Ehren (MSFT) 1,786 Reputation points Microsoft Employee2021-03-19T21:13:02.737+00:00