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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
Super User
Super User

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
Super User
Super User

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.