Forum Discussion

ssk_1984's avatar
ssk_1984
Helper II
2 years ago

Calculate column level average by multiple category

Hi Team,   help to add column to calculate average by multiple category. Here i want to calculate the Average of logged hours by adding new column for the criteria, Outliers should be no, group by...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

ssk_1984 , Try a new column like

 

averageX(filter(Table, [Employee ID] = earlier( [Employee ID] ) && [Converted Month] = Earlier([Converted Month]) ), [Logged])

or

if([Outlier] = "No", averageX(filter(Table, [Employee ID] = earlier( [Employee ID] ) && [Converted Month] = Earlier([Converted Month]) ), [Logged]), blank())

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s