Forum Discussion

Riddell2022's avatar
Riddell2022
New Member
4 years ago

Average

Good morning    I'm having an issue with finding a dax calculation to do something similar to excel please help!   I have a list of students 300 to be exact. Each student has been banded in to a ...
amitchandak's avatar
amitchandak
Super User
4 years ago

Riddell2022 ,

a new column

averageX(filter(Table, [Band] =earlier([Band]) && [subject] =earlier([subject]) ), [score])

 

New measures

averageX(filter(allselected(Table), [Band] =max([Band]) && [subject] =max([subject]) ), [score])