Solved: wait time display error

Anonymous · ‎03-11-2021

hi

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

amitchandak · ‎03-11-2021

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Anonymous · ‎03-15-2021

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

amitchandak · ‎03-11-2021

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube