Forum Discussion
Calculating Average question
Hi everyone, I am new to power bi and I am starting a report where the source file is a basic excel file. I have created a matrix and added the data I needed it, please see the attached. My chal...
Ashish_Mathur
Super User
Super UserHi,
Assuming the numbers in the matrix are the result of this measure
Value = sum(Data[Amount])
try this measure
Value revised = if(hasonevalue(Calendar[Year]),[Value],averagex(values(calendar[Year]),[Value]))
Hope this helps.