Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Rangesum() function in Power BI

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 ...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

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