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 help is appreciated!

 

Need Help

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity 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