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 essentially need to Calculate Hourly Rate * Sum of Hours for User.
Table: HR Data (This table has one row for each user)
User ID, Hourly Rate
450294, $40
345020, $56
837498, $43
Table: Time Log Data (This table has many rows for users with many projects and dates
User ID, Project, Hours
450294, Project A, 20
450294, Project B, 80
450294, Project C, 5
345020, Project A, 40
345020, Project B, 40
345020, Project C, 20
837498, Project A, 13
837498, Project B, 20
837498, Project C, 5
Any ideas? I'm open to doing a measure OR creating a new table. But I was not able to make a custom column in one table because I could not get it to pull data from the other.
Solved! Go to Solution.
@Anonymous
You can create a relationship between the two tables and use the following measure. Insert a Table Visual on the canvas, insert user id from User table and the measure
Total =
SUMX(
Users,
Users[ Hourly Rate] * CALCULATE(SUM('Time Log'[ Hours]))
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
You can create a relationship between the two tables and use the following measure. Insert a Table Visual on the canvas, insert user id from User table and the measure
Total =
SUMX(
Users,
Users[ Hourly Rate] * CALCULATE(SUM('Time Log'[ Hours]))
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thank you, this is exactly what I needed!
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |