I'm trying to calculate the average across serveral columns of data but a single row, but the examples i've looked it it only involves columns
So for above i would like the average for the country of Albania from 1995-2000 and the result shown in a seperate column called Average by Country. Been a novice to Power BI i thought this could be achieved using Quick Measure.
Why can't you select rows in Power BI and only Columns???. I was thinking you could select a row then use New Quick Measure
I think it would be best to restructure the data in your table. Use the Pivot/Unpivot feature inthe query editor to get the table in the form shown below. Then you can do what you are looking for in a much more convenient way.
i get the warning: The AVERAGE function only accepts a column reference as an argument.
In this instance I can confirm @affan method is indeed the quickest way to solve this solution, but none the less i'm intrested in getting the Unpivot Scenario working as it seems for want of a better word cleaner should more data be added at a later date