Forum Discussion
Value.Divide and List.Average giving Infinity and Null values
I am creating 2 reference tables off a source table. I am first grouping the first table into a "By Order" Average table, then grouping that table into a "By Part #" average table. By the time I get ...
Hi powerboss ,
This error may be caused by an inappropriate values(0, NULL or text value etc.) in the divisors. How did you create Order average table and Part average table? If it is in Power Query Editor, could you please provide some sample data of source table and applied step codes(exclude sensitive data) of new tables in Advanced Editor? Is there any column with 0 or null value?
In addition, please check if the below method can resolve your problem.
if [divisor]=0 or [divisor]=null then 0 else Value.Divide([Dividend],[divisor],0)Best Regards
Rena