Forum Discussion
Solved
Getting an average where columns match
Hi there friends, I have data like below: IDPerson Job type Job option Job category Hourly rate Average rate 134 Type 1 Option 1 On-site 60 58,33 13...
Hi JGroothedde - create a below calculated column that dynamically calculates the average for each row based on the specified conditions
calculated column:
Average rate =CALCULATE(AVERAGE('Avger'[Hourly rate]),ALLEXCEPT('Avger', 'Avger'[Job type], 'Avger'[Job option], 'Avger'[Job category]))Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Hi JGroothedde - create a below calculated column that dynamically calculates the average for each row based on the specified conditions
calculated column:
Average rate =
CALCULATE(
AVERAGE('Avger'[Hourly rate]),
ALLEXCEPT('Avger', 'Avger'[Job type], 'Avger'[Job option], 'Avger'[Job category])
)
Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Thank you so much for getting me out of this, for some reason I kept trying to do this in a measure. Thanks!