Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

wait time display error

hi

i am trying to display waiting time calculation but i am getting an error

 

 

Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , I these are in time format. So you can add subract. To get hour or minute , you need function

     

    Hour([Time]) + minute([Time]) /60

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , I these are in time format. So you can add subract. To get hour or minute , you need function

     

    Hour([Time]) + minute([Time]) /60

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Anonymous,

    How did your data fields store? AFAIK, current power bi does not allow you to directly calculate between time and numerice type values.

    How to Get Your Question Answered Quickly

    Regards,
    Xiaoxin Sheng