How to do average or averagex in row-wise.

[Anonymous]

Hi,

I like to perform average in row wise. I have a big table but I like select a certain amount of column and then I want to take average in row-wise. 

How can do that. Please kindly help.

Regards

Abdullah

[lbendlin]

Unpivot your data, either in Power Query or in DAX.  You can create tables out of columns of a row on the fly in DAX by using the { } syntax.  Then you can use averagex over that table.

Table constructor - DAX | Microsoft Docs