Forum Discussion
Custom column - Average excluding "NA" values
Dear all, I kindly need your expertise for creating a custom column that calcuates the average of several columns. The problem is I have a dataset that includes some "NA" values: White Bl...
Use something along the lines of:
Measure = AVERAGEX(FILTER('Table',[Yellow]<>"NA"),[Yellow])Option 1: As pointed out use filter in your query
Option 2: Default value to 0 when blank or NA occurs that way your regular calculation would work.
Hi Anonymous,
Based on my test, you could refer to Greg_Deckler's solution, also, you could refer to replace the 'NA' value in query editor:
Hope it could help you.
Regards,
Daniel He
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He