Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 when I use MAX in this case, then my Power BI report uses 125 for each month for 'Standard'.
Would an Switch statement work in this case?
Solved! Go to Solution.
Assuming that you have an calendar table in your model, you can create this measure:
Or month
Regards,
Sérgio Silva
Hi,
How has Standard been calculated? Share the download link of the PBI file. Show the expected result.
Assuming that you have an calendar table in your model, you can create this measure:
Or month
Regards,
Sérgio Silva
This worked...thanks!!
Glad i could help!
'Daily Avg Standard' (or Standard) needs to be multiplied by the 'Days Worked'. However, I cannot do this because 'Days Worked' is a measure and 'Daily Avg Standard' is a column.
Hi @i820017 ,
What is standard calculating? Do you have an PBIX example?