Forum Discussion
Replacing null with mean
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
Anonymous , a new column in DAX
If(isblank([review_per_month]), avergage([review_per_month]),[review_per_month])
2 Replies
Anonymous , a new column in DAX
If(isblank([review_per_month]), avergage([review_per_month]),[review_per_month])