cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

employee hour summary with redundant data

I'm stuck!

I have a table of raw data that includes employee name, project, and hours worked by employee and client and project.  (Sample data attached).  The data for the Holiday Hours, Paid Time Off Hours and Total Time Off Hours are duplicated and therefore are summed incorrectly.  The data is stored in a database where the billable hours and non billable hours are separated, but count the time off and holiday for each row and it should not be.  I don't know how to either remove the redundant data or parse out the data to create a new table join.  No matter what I get errors because of many employees, many dates, and many clients (not finding the unique value)

.Example2.JPG

1 REPLY 1
Community Support
Community Support

hi, @ssutton

How do you determine that which row of data is redundant? From your screenshot, I couldn't find the logic of how to determine which row of data is redundant. And It seems that you just want to replace the redundant Holiday Hours/ Paid Time Off Hours/ Total Time Off Hours with 0 and keep using other column data of the redundant data row. So I suggest you add three new columns: new Holiday Hours/ new Paid Time Off Hours/ new Total Time Off Hours 

logic like this:

new Holiday Hours = IF( conditional , 0 , Holiday Hours)

new Paid Time Off Hours = IF( conditional , 0 , Paid Time Off Hours)

new Total Time Off Hours = IF( conditional , 0 , Total Time Off Hours)

 

Then use these three new columns to create the visual.

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors