Power BI

Power Query: Insert Sum Rows for Dynamic Periods

  Sample Table In the following scenario, I would like to insert a sum row for each 5 days as an example.   Method 1       let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(“bdBLCsAgDATQu7iWkon1dxbx/tdoAqWQjrh7yiTjWklFcdlJOUEk7fyRGtUgxaQHuU1GkGrSgjR60yl5+HgEmhRk9/8k+N4zknIV+ObQaL47SrTKExqVRj+kjcPUST1VqJWCib9ey7vZfgA=”, BinaryEncoding.Base64), Compression.Deflate)), let […]