Forum Discussion
WARNING Message when work hours exceeds planned hours (Sum vs. specific value)
Hello! I got a chart with planned and actually booked work hours and would like to visualize the current status of those work hours in a new column. Unless booked hours are below planned hours, S...
Hi Anonymous,
Current power bi desktop not support analytics specific value and send warning measure when value exceed to plan.
>>How can i create a new column, checking the sum of all work hours of a project with one specific value?
I'd like to suggest you to use current row 'project number' to find your correspond records to calculate 'book hour' and 'plan hour' and cycle difference between them and stored in variable.
After these calculation, write a if statement to group result as different statues.
If you still confused on coding formula, please share some sample data for test.
Regards,
Xiaoxin Sheng