Forum Discussion
i820017
Resolver II
Resolver IIColumn to Measure
The following table is data that I entered in manually. Is there any way that I can convert the column entitled 'Standard' into a Measure? Normally, I use MAX to do this, but the problem is that whe...
Assuming that you have an calendar table in your model, you can create this measure:
Standard=AVERAGEX('Calendar',CALCULATE([Days Worked] * SELECTEDVALUE(Tbl[Daily Avg Standard])))Where 'Calendar' should be the name of your calendar table, and Tbl the name of the table where the column Daily Avg Standard is.It should work has intended:By dayOr month
Regards,
Sérgio Silva
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
SergioSilvaPT
Resolver V
Resolver VAssuming that you have an calendar table in your model, you can create this measure:
Standard=
AVERAGEX(
'Calendar',
CALCULATE(
[Days Worked] * SELECTEDVALUE(Tbl[Daily Avg Standard])
)
)
Where 'Calendar' should be the name of your calendar table, and Tbl the name of the table where the column Daily Avg Standard is.
It should work has intended:
By day
Or month
Regards,
Sérgio Silva
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
i820017Resolver II
Resolver IIThis worked...thanks!!
- SergioSilvaPT
Glad i could help!