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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Citah
Regular Visitor

Power bi Power Query

i have been using this formular

=[Headcount] / List.Sum("Changed Type"[Headcount])

to calculate my percentages in the old version of power bi but after updating power bi to the latest version, i get errors when using this. The following is an error i received

Citah_0-1652353410844.png

Kindly assist or advise, am on my deadlines and this percentage is stressful. Any steps to follow?

Kind Regards

 

5 REPLIES 5
v-kkf-msft
Community Support
Community Support

Hi @Citah ,

 

Please make sure you apply step "Changed Type" before adding the custom column.

 

vkkfmsft_0-1652691757216.png

 

If the problem is still not resolved, please provide detailed M code. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you but the problem is still there

Citah_0-1652864825059.png

 

This is the code requested i believe;

= Table.AddColumn(Source, "Custom", each [QuestionTwoStars] / List.Sum(#"Changed Type"[QuestionTwoStars]))

 

Hi @Citah ,

 

Maybe you can try these code.

 

 

= Table.AddColumn(Source, "Custom", each [QuestionTwoStars] / List.Sum(Source[QuestionTwoStars]))

 

 

Or

 

= Table.AddColumn(#"Changed Type", "Custom", each [QuestionTwoStars] / List.Sum(#"Changed Type"[QuestionTwoStars]))

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Citah , I think table name should have #

 

[Headcount] / List.Sum(#"Changed Type"[Headcount])

 

Power Query- List.Sum. Sum of a column in Power Query : https://youtu.be/Mud1RSqW5pw

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I tried all that too...its actually the one that worked at first but now it shows and error

Citah_0-1652355536336.png

This is the error

Citah_1-1652355566010.png

 

 

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

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.

Top Solution Authors
Top Kudoed Authors