Forum Discussion
Helper IIList may be incomplete -power query
While creating a custom column on power query with below formula
[AVG]/ list.sum([AVG]) , I am getting msg 'List may be incomplete'.I have checked 'Select All' option , am I missing anything here?
Hi again 🙂
Please refer to the linked video, it is not the same syntax:
https://www.youtube.com/watch?v=tT4GeYpT2xs
Additionally, Rick provides two extra methods as a bonus.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
tina345I am trying to create a custom column to calculate percentage of grand total for 'AVG' column.
custom column = [AVG]/ list.sum([AVG])
- Ritaf1983
Super User
Hi again 🙂
Please refer to the linked video, it is not the same syntax:
https://www.youtube.com/watch?v=tT4GeYpT2xs
Additionally, Rick provides two extra methods as a bonus.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly