Forum Discussion
Multiply with averages
Hi all, I have the following question. I have trouble to multiply an average with an absolute number, I think it is because there is no link between the tables posible. I have the following ...
My suggestion:
- Use the Query Editor to unpivot the Hours per person per location table. the result should be:
Personal nr Location Hours 1 Location 1 10 1 Location 3 10 2 Location 1 10
- Connect the now-unpivoted table to the Average cost per hour per person table by Personal nr.
- Create a Measure:
Cost per Location=
SUMX('Hours per person per location',
SUM('Hours per person per location'[Hours]*RELATED('Average cost per hour per person'[Average cost per hour])
)
Give it a try.
- Use the Query Editor to unpivot the Hours per person per location table. the result should be:
My suggestion:
- Use the Query Editor to unpivot the Hours per person per location table. the result should be:
Personal nr Location Hours 1 Location 1 10 1 Location 3 10 2 Location 1 10
- Connect the now-unpivoted table to the Average cost per hour per person table by Personal nr.
- Create a Measure:
Cost per Location=
SUMX('Hours per person per location',
SUM('Hours per person per location'[Hours]*RELATED('Average cost per hour per person'[Average cost per hour])
)
Give it a try.