Powerquery column based off entire table values

[Ad550]

How can I add a new powerquery column that references the entire table.   For example, I have a table of students with a column for grades on an exam and another column for study time (either under 3 hours, 3-6 hours or > 6 hours).   I want to add a column called "predicted grade" that calculates the average student grade across the whole table based on the students study time.  So for example if a row (student) has a study time value of under 3 hours, then then the predicted grade value for that row should be the average grade of all students in the table who had that same value (of under 3 hours) for study time.  

How can I add a new column like this that references an entire table calculation and filters it based on each row value?

thanks! 

[Anonymous]

Hi  @Ad550 ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards

[Anonymous · Accepted solution]

Hi @Ad550 ,

Please check my reply in the below thread:

Create a PowerQuery Column That References Entire Table

Best Regards

[Dinesh_Suranga]

@Ad550 

Hi,

Could you please share some sample data and expected result.

Thank you.