How to Peform Row wise Average calculation

[Vijay08V]

Hi,

I need some help on how to perform row wise calculation. Below is the Table format and I want to create a calculated column giving average of Sub1,Sub2 and Sub3 in Average% col for each row.

Student Name	Sub1	Sub2	Sub3	Average %
A	2	3	4	3
B	4	2	5	3.67

[tamerj1 · Accepted solution]

Hi @Vijay08V 

please try

=
DIVIDE ( 'Table'[Sub1] + 'Table'[Sub2] + 'Table'[Sub3], 3 )