Forum Discussion
Solved
Column 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.
This worked...thanks!!
Glad i could help!