Average of 2 columns

[Tobias106]

Hello everybody,

in Excel I have 2 columns with values. 

I would like to sum up all this values of the 2 columns and get the average of this result.

Do you have an idea?

Thank you in advance

Tobias

[amitchandak · Accepted solution]

@Tobias106 , Try measure like

AverageX(union(Values(Table[Val1]),Values(Table[Val2]) ), [Val1])