Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |