The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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
@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.