Forum Discussion
Solved
Custom column
Hello everyone, i'm just a beginner with power query so i'm not sure how to solve this issue i have. I'm looking to add a custom column where if the weight value is zero then it should take the ...
I think you want the average of the non-zero entries for the same date.
Here's what I would do:
Duplicate the query.
Filter out the 0 entries (from the column header).
'Group By' Date and Product Code with a new column for the Average of Weight
---
Merge this table back to the original table on (Date, Product Code) to get the Average on each row.
HotChilli
Community Champion
Community ChampionI think you want the average of the non-zero entries for the same date.
Here's what I would do:
Duplicate the query.
Filter out the 0 entries (from the column header).
'Group By' Date and Product Code with a new column for the Average of Weight
---
Merge this table back to the original table on (Date, Product Code) to get the Average on each row.