Forum Discussion
Calculation time increases for each added Calculated Column - Power Query
Hi Anonymous ,
For calculating PERCENTILE in Power Query, you can refer to this post:
How do I calculate Percentiles in PowerQuery based on grouping variables?
Best regards
Icey
If this post helps,then consider Accepting it as the solution to help other members find it faster.
The error was because of a typo `AverarageAttrb6` in this line:
InsertedAttrb6AvgPercent = Table.AddColumn(InsertedTotal, "Attrb6 Avg%", each [Attrb6]/AverarageAttrb6,Percentage.Type),
After changing that, it is working.
Which list are you referring that is causing the loading issue? How do i resolve it correctly?
Any Idea on how to calculate PERCENTILE in Power Query for the last 3 columns?
Hi Anonymous ,
For calculating PERCENTILE in Power Query, you can refer to this post:
How do I calculate Percentiles in PowerQuery based on grouping variables?
Best regards
Icey
If this post helps,then consider Accepting it as the solution to help other members find it faster.