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.
Hi community,
I have the following visual:
I want to add a measure that calculates the difference like this:
Both columns Worked.1 and Worked Hours come from two different tables that are connected through a relationship. Is there another way to add a difference column in the Visual that keeps the same layout as the first picture, and does not create duplicates of the users?
The table 'apticproject view_workedtime' looks like this:
the table v_rpt_apticcustom_Employee_Time_Billingv6 looks like this:
My end goal is to create another column in the visual that uses a measure and looks something like this =IF([Diff]>=0,[[Worked Hours]],[[Worked.1]]). How can I write this measure properly? Or should a calculated column be used instead of a measure?
Solved! Go to Solution.
Hi @amitchandak I managed to solve the issue, I had a department column that was causing the duplications, so I removed that. The department column was from the employee table but it was not connected to any other table.
looks much better now:
Now I want another column in the visual that uses a measure and looks something like this =IF([Diff]>=0,[Worked Hours],[Worked.1]). How can I write this measure properly? Or should a calculated column be used instead of a measure?
This measure worked for me:
@darko861 , How these tables are joined. From where the Employee name column (first column) is coming.
is it Many -Many ?
Hi @amitchandak I managed to solve the issue, I had a department column that was causing the duplications, so I removed that. The department column was from the employee table but it was not connected to any other table.
looks much better now:
Now I want another column in the visual that uses a measure and looks something like this =IF([Diff]>=0,[Worked Hours],[Worked.1]). How can I write this measure properly? Or should a calculated column be used instead of a measure?
This measure worked for me:
hi @amitchandak, it's a one to many relationship
the yellow highlighted at the top is worked time table, the bottom left is the employee table and the bottom right is the user table which connects the tables based on userid (worked time) and memberid (employee table)
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 |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |