Rangesum() function in Power BI

[Anonymous]

Hi All,

I've tried to get the sum of a field vale based on numeric range values like have values as (1,2,3,4,5,6,7,8) in one field and i need sum(1+2+3+4) & sum(5+6+7+8) in seperate column.

Any help is appreciated!

[v-lili6-msft]

hi, @Anonymous

After my test, you could do these ways to achieve it.

Step1:

In edit queries, select the column then duplicate the column

Step2:

Select the duplicate column then click Transform->Split Column->By delimiter

Step3:

then add two custom columns

Result:

Best Regards,
Lin