Forum Discussion

mikeoshields's avatar
mikeoshields
Icon for Helper I rankHelper I
5 years ago

Column Calculations in a Matrix

I have a PowerBI matrix of 6 columns of data...see below. The values are the sums of the last 6 months.    The example Excel worksheet below averages those 6 columns and does other calculatio...
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
5 years ago

You need to post

* your table structure

* your relationships

 

if you don't do this, it's like phoning your mechanic and saying "my car won't start, what's wrong"?

  • mikeoshields's avatar
    mikeoshields
    Icon for Helper I rankHelper I
    5 years ago

    I know I know...the thing is we're a DOD supplier so I have to be VERY careful.  Let's attack this from a different perspective (forget the actual data)...What is the right way to get the average of values in a matrix (see below)?  Again, in this case QTY_LOCATION is pivoted into monthly totals.  I just need to get the average of the monthly totals in a measure or column (not sure which).  If this isn't sufficient, I will make up some data since I can't send my raw data.