cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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, 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

 

powerbi.png

2 REPLIES 2
Super User IV
Super User IV

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

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.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Community Support Team
Community Support Team

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

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors