Forum Discussion

SBC's avatar
SBC
Icon for Helper III rankHelper III
3 years ago

How to summation in power bi

Hi,

 

How to do summation for a particular row in power bi 

Input data:

 

curveexpsuv
LX_qwr                12                        16
NS_MEX-24
NS_AOC10-34.56
NS_XTV-22.4022.42
AC_X1C-33.5222

 

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:

curveexpsuv
LX_qwr12                      16
NS_MEX-47.9213.86
NS_AOC       10-34.56
NS_XTV-22.4022.42
AC_X1C-33.5222

 

 

 

Thanks,

SBC

Interesting Links
Need Help
Tips and Tricks

1 Reply

  • serpiva64's avatar
    serpiva64
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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!