Sum of range of columns in power query

vikasdk 1 Reputation point
2021-09-02T12:20:15.057+00:00

I am new to power query and need some help. I have 25 columns and 10k rows table with value data in it. I want to create custom column which will result the sum of specific range of columns. i.e. sum of the data from 3rd column to 10th column. I wish to have this formula dynamic, means the range of number of columns (above I have selected as 8 ) will vary every month. I could achieve it thru "Offset" function in excel but not able to do so in Power query. Please advice.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,108 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Herbert Seidenberg 1,191 Reputation points
    2021-09-02T18:41:36.817+00:00

    Excel 365 Pro Plus with Power Pivot and Power Query.
    Sum selected columns.
    UnPivot with PQ, then pivot with PP.
    Select with Slicer and TimeLine.
    Way beyond beginner.
    https://www.mediafire.com/file/ydv3s5i13kl78wl/09_02_21.xlsx/file
    https://www.mediafire.com/file/g15ywgr8wuuqbo0/09_02_21.pdf/file