Forum Discussion

tina345's avatar
tina345
Icon for Helper II rankHelper II
2 years ago
Solved

List 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? ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

Hi tina345 
What are you trying to achieve?

tina345's avatar
tina345
Icon for Helper II rankHelper II
2 years ago

I am trying to create a custom column to calculate percentage of grand total for 'AVG' column.

 

custom column = [AVG]/ list.sum([AVG])

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    2 years ago

    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