Calculate Average excluding gaps

[flexxus]

Hello! I have a visual object type "Matrix" that shows in a column the "Clients", "Year 2016", "Year 2017", "Year 2018", "Year 2019" I need to calculate a new column that calculates the average of the last 3 years (2016 + 2017 + 2018) per client.

Example:

When a year does not contain value, I need the average to calculate it dividing only by values ​​other than "null". Example: The family "APPAS VICTOR EDUARDO" should calculate the average = (229.324 + 135.134) / 2 = 182.229 The truth is that I do not know how to calculate it. In Excel I use the function Average.SI and exclude the 0. Can someone help me or guide me?

This is a screen print of my table in Power BI:

Thank you!

[Greg_Deckler]

Is that how your source data is formatted? I would highly recommend that you unpivot your year columns. Should mame what you are trying to do much simpler.

[flexxus]

Thanks Greg! The origin data are the different sales that were made. My client requests to see all those accumulated sales for the different years. How would you say I should show it?