Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Ilka719
Frequent Visitor

Sumif in PowerBI table

Hi!
How can I get the result of Table 2, if I have Table 1?
Names with "+" sum into one corresponding name.
For example:

Ilka719_0-1692270687758.png

 




 

1 ACCEPTED SOLUTION
eliasayyy
Memorable Member
Memorable Member

i dont know how to do it in dax but in power query 

go to transform

annonymous1999_0-1692275170731.png


press on the Name column choose split by delmiter 

annonymous1999_1-1692275210681.png

 

now the delimiter is custom and "+" 

and press advanced and choose by row

annonymous1999_2-1692275250962.png


result

annonymous1999_3-1692275263314.png

 

now group your name by sum of sum 

annonymous1999_4-1692275285404.png

 

annonymous1999_5-1692275301024.png

 

final result

annonymous1999_6-1692275312421.png

 



View solution in original post

2 REPLIES 2
eliasayyy
Memorable Member
Memorable Member

i dont know how to do it in dax but in power query 

go to transform

annonymous1999_0-1692275170731.png


press on the Name column choose split by delmiter 

annonymous1999_1-1692275210681.png

 

now the delimiter is custom and "+" 

and press advanced and choose by row

annonymous1999_2-1692275250962.png


result

annonymous1999_3-1692275263314.png

 

now group your name by sum of sum 

annonymous1999_4-1692275285404.png

 

annonymous1999_5-1692275301024.png

 

final result

annonymous1999_6-1692275312421.png

 



Thank you!!!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.