Calculating average of N columns in a single row (Basically horizontal operations) in POWER BI

[tanmaykaushik]

Dear Community,

What I am struggling to solve as a beginner is that what if there are many more rows in your dataset and you want to perform an operation or add a new column that calculates the average/total of you table data full of numbers both horizontally and vertically. Just like in Excel where a sum etc. can be applied to add a new final column as well as a row. (PLEASE REFER EXCEL EXAMPLE)

Could someone please tell me if there is a way to calculate totals/averages/etc for 'n' columns in Power BI horizontally? Just like the sum function works in Excel over the whole row operating on every column in the ROW. 

THIS IN THE END HELPS ME MAKE CHARTS AND OTHER ANALYSIS IN EXCEL, I WANT TO ACHIEVE THE SAME IN PBI. 🙂

Appreciate the help. Thank you

[lbendlin · Accepted solution]

This will hurt a little.  Forget everything Excel taught you.  Power BI is expecting long, narrow tables. To bring your data into usable format, unpivot it.

After that your formulas write themselves, or you may not even need any explicit formulas.