Max of Multiple Columns in a row using DAX

[Fahadfx]

Hi,

I have 8 columns with test scores and I want to return the Max value for these scores in a column. I have a way of doing that using if but it's long.

Is there any other way to do it.

I have to use powerpivot as the data is large and can't be saved in excel and use Max().

Thanks