Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
 
					
				
		
@Kurumi0418,
Please take a look at the following similar thread about how to use sum function in custom column. If you have questions about the code, please share sample data of your tables and post expected result based on sample data here.
https://community.powerbi.com/t5/Desktop/How-to-Sum-columns-in-edit-queries/td-p/75060
Regards,
Lydia
 
					
				
		
@Kurumi0418,
Please take a look at the following similar thread about how to use sum function in custom column. If you have questions about the code, please share sample data of your tables and post expected result based on sample data here.
https://community.powerbi.com/t5/Desktop/How-to-Sum-columns-in-edit-queries/td-p/75060
Regards,
Lydia
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 80 | |
| 49 | |
| 35 | |
| 31 | |
| 30 |