How to summation in power bi

[SBC]

Hi,

How to do summation for a particular row in power bi 

Input data:

curve	exp	suv
LX_qwr	12	16
NS_MEX	-2	4
NS_AOC	10	-34.56
NS_XTV	-22.40	22.42
AC_X1C	-33.52	22

we need to sum only which starts with NS_ and we need to show that total under NS_MEX,remaining curve should be show as it is without any change.

Expected output:

curve	exp	suv
LX_qwr	12	16
NS_MEX	-47.92	13.86
NS_AOC	10	-34.56
NS_XTV	-22.40	22.42
AC_X1C	-33.52	22

Thanks,

SBC

[serpiva64]

Hi,

you can get this by using UI (

take a look at the attached file

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!