Replace null values with average using Power Query

[gsamaral77]

Hey guys, I'm studying Power Query but I'm stuck

I have a column "Age" with some null values, I want to replace those with the average. 

That's what I try to do:

I don't no what I'm doing wrong, someone can help me please?

[Vijay_A_Verma · Accepted solution]

Insert this statement

= Table.ReplaceValue(#"Tipo Alterado",each [Age],each if [Age] = null then List.Average(#"Changed Type"[Age]) else [Age],Replacer.ReplaceValue,{"Age"})

[Anonymous]

That's a good solution! I would actually calculate the List.Average first, make us a variable, so it'll calculate only once. So

avg = List.Average(#"Changed Type"[Column])

The in the formula, just replace the text above with avg

--Nate