question

JabaArchuadze-2998 avatar image
0 Votes"
JabaArchuadze-2998 asked ·

how to insert specific row

Is it possible to add a row in the table that summarizes all the rows above it? [1]: /answers/storage/attachments/79231-capture.png [2]: /answers/storage/attachments/79120-result.png

power-query-m
capture.png (5.3 KiB)
result.png (6.7 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Ehren avatar image
0 Votes"
Ehren answered ·

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?

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.