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.
Hello, I am a beginner learner of Power BI and having an issue with duration formatted hh:mm:ss. I have customer service Power BI table. I have serveral formated columns as duration. I need to be able to create a measure for a few durations
Below is the custom column I use in excel power query how can I do this in Power BI:
CallsAnsIn30=Value.Divide(Value.Multiply[ANS],[#"%SL']),100)
TotalSpeedtoAnswer=Value.Multiply([ANS],[ASA])
ASA = TotalSpeedtoAnswer/ANS
SL% = CallsAnsIn30/ANS
Also, I have serveral duration I need to average ex. for average handle time. I can do this in excel power query but don't know how to do in Power BI as the row I need to average are not available to create an average.
any help would be greatly appreciated, Thank you, Lily
Solved! Go to Solution.
Sample data would help, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But it sounds like you want something like this: https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639
Sample data would help, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But it sounds like you want something like this: https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639
Again, please forgive me as I am a new user to Power BI.
below is the measure I am using. How do I get the answer of my average to show in Visualizations as hh:mm:ss?
Talk = (AVERAGE(fTransactions[Talk.0]))
an example, the answer of the above measure is 346 . I need the 346 formated as 00:05:46 in any one of the Visualizations.
Thank you in advance for your help
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 |