how to average 4 columns

[CLCastroEn]

Hello everyone!

I am making a report, in which I have 4 columns of forecasts (week 40, 41,42,43) and I must create a new column with DAX that allows to average these 4 columns.

The result is that the new column each row that has been the average of the previous ones.

Stay tuned! Thanks a lot

[v-kelly-msft · Accepted solution]

Hi @CLCastroEn ,

First create an index column,then select the 4 week columns>unpivot;

Then create a matrix,right click on the value field>average:

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mahoneypat]

You should unpivot your week columns in the query editor.  It will simplify your analysis. If you provide example starting data and desired output, a specific expression can be suggested.

Regards,

Pat

[Pragati11]

Hi @CLCastroEn ,

Can you share some sample data around your problem and what the expected output please?