Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

query to form a measure

hiii

i have created a calculated column to cal culate waiting tym what is the query to form a measure

waiting tym = MOD( ('Phone Call Data'[Disconnect Time]-'Phone Call Data'[Connect Time]-'Phone Call Data'[Hold Time]-'Phone Call Data'[Talk Duration]),60)
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    6 years ago

    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 🙂

    YouTube, LinkedIn

    • mahoneypat's avatar
      mahoneypat
      Icon for Microsoft Employee rankMicrosoft Employee
      6 years ago

      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

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    6 years ago

    @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 🙂

    YouTube, Linkedin

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      no sorry its not the correct solution

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Pls share some sample data and expected output to help you better

     

    Thanks

    Harsh Nathani