Forum Discussion

Vijay08V's avatar
Vijay08V
Icon for Helper III rankHelper III
4 years ago
Solved

How to Peform Row wise Average calculation

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 NameSub1Sub2Sub3Average %
A2343
B4253.67

1 Reply

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Vijay08V 

    please try

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