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 have been trying to create a measure that will accruately show me the time per person in Power BI related to talk time. So calcualting how much each person has for talk time but the formulas I am trying keep giving me the wrong answer. I am trying to caluclate the total talk time and then add each "Agent Name"(column with all agents) and show what each agents talk time is.
I have the column (BILL TIME)in power query already set to duration which shows the correct duration .
I have tried running these two formulas
talk_time = VAR Elapsed_Time = SELECTEDVALUE(data[BILL TIME ])
VAR days = INT(Elapsed_Time)
VAR _hrs = (Elapsed_Time - days) = 24
VAR hrs = INT(_hrs)
VAR mins = ROUND((_hrs - hrs) * 60,0)
Return
days & " d " & FORMAT(hrs,"00") & " h " & FORMAT(mins,"00") & " m "
any other way I can do this?
Solved! Go to Solution.
Another approach you can try (if your total duration is <24 hrs) is an expression like this.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Another approach you can try (if your total duration is <24 hrs) is an expression like this.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you! exactly what I am looking for!
Sorry! I see your values are already decimal...in other words, already divided by 86400. This greatly simplifies the whole thing:
I do it as follows. I make a Divisor Measure:
Hey Nate, tried out your steps and I dont beleive it is working. this is the result I am getting for one person when it shuld my multiple hours.
thanks nate, tried out those steps but dont believe its working unless I am doing something wrong
@Johnny-Mclawdog Try Chelsie Eiden's Duration: Chelsie Eiden's Duration - Microsoft Power BI Community
anyway that breaks it up into hours minutes seconds to be able to add all together?
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.