Forum Discussion
Get the average value per row with multiple columns
How to get the Average value with rows As you can see in the table below. I want get the average value for each row. I have tried so many things. AVERAGEX(Table, Table[City 1]+Table[City 2]+T...
Anonymous , do you have these cities as separate columns? I would unpivot them first, otherwise you'll have to define each value with SELECTEDVALUE, for example AVERAGEX(Table, SELECTEDVALUE ( Table[City 1] )+ ... ).
Could you sum them and divide by 3?