Power bi Power Query

[Citah]

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

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

Kind Regards

[v-kkf-msft]

Hi @Citah ,

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

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.

[Citah]

Thank you but the problem is still there

This is the code requested i believe;

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

[v-kkf-msft]

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]

@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

[Citah]

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

This is the error