Replacing null with mean

[Anonymous]

Hi All,

I have a situation where i want to replace null values with the mean value of that column.

What's the best way to do it in Power BI?

Regards,

Himanshu

[amitchandak · Accepted solution]

@Anonymous , a new column in DAX

If(isblank([review_per_month]), avergage([review_per_month]),[review_per_month])

[Anonymous]

Thanks it helped.

Regards,

Himanshu