WARNING Message when work hours exceeds planned hours (Sum vs. specific value)

[Anonymous]

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, Status should be "in time". If booked hours exceeds planned hours, Status should be "Warning".

The thing is: The planned hours come from an excel sheet with one specific value for each project. The value of work hours actually is a sum of multiple bookings coming from a big database.

My question now is: How can i create a new column, checking the sum of all work hours of a project with one specific value? Thanks in advance

[v-shex-msft]

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

[Greg_Deckler]

If the tables are related to one another via Project number than you could do something like a SUMX of RELATEDTABLE to get the sume of the work hours in your column formula in your Projects table.