Forum Discussion
Automated row for averages in Power Query
Hi there, so my question is that in power query is there a way for me to get a new column that shows the average of values in a row? The number of columns will be updated on a daily basis. So, would ...
Hi bsrujan022 ,
Try this as a new custom column:
List.Average( List.RemoveFirstN( Table.ColumnNames(previousStepName), 1))
Pete