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.
hiii
i have created a calculated column to cal culate waiting tym what is the query to form a measure
Solved! Go to Solution.
Hello @greeshma
use the following
waiting tym =
MOD(
( SELECTEDVALUE('Phone Call Data'[Disconnect Time]) -
SELECTEDVALUE('Phone Call Data'[Connect Time]) -
SELECTEDVALUE('Phone Call Data'[Hold Time]) -
SELECTEDVALUE('Phone Call Data'[Talk Duration])
)
,
60
)
Did I solve your problem? Mark my position as a solution!
We appreciate your congratulations, press the thumbs up button !!
Best regards
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi @Anonymous ,
Pls share some sample data and expected output to help you better
Thanks
Harsh Nathani
@greeshma
Hi, can you check and let me know if the solution I provided worked for you please?
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
no sorry its not the correct solution
Thanks for the feedback
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hello @greeshma
use the following
waiting tym =
MOD(
( SELECTEDVALUE('Phone Call Data'[Disconnect Time]) -
SELECTEDVALUE('Phone Call Data'[Connect Time]) -
SELECTEDVALUE('Phone Call Data'[Hold Time]) -
SELECTEDVALUE('Phone Call Data'[Talk Duration])
)
,
60
)
Did I solve your problem? Mark my position as a solution!
We appreciate your congratulations, press the thumbs up button !!
Best regards
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@Anonymous
Use the following as measure
waiting tym =
MOD(
( MAX('Phone Call Data'[Disconnect Time]) -
MAX('Phone Call Data'[Connect Time]) -
MAX('Phone Call Data'[Hold Time]) -
MAX('Phone Call Data'[Talk Duration])
)
,
60
)
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Please try this expression. If you don't want the total waiting time, you can use AVERAGEX instead to get average waiting time.
waiting tym =
DIVIDE (
SUMX (
'Phone Call Data',
'Phone Call Data'[Disconnect Time] - 'Phone Call Data'[Connect Time] - 'Phone Call Data'[Hold Time] - 'Phone Call Data'[Talk Duration]
),
60
)
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |