Forum Discussion
How to subtract time
Hi, I'm fairly new to Power Bi and would appreciate assisstance on the following: I am trying to work out the difference between planned and actual time. As you can see in image below : SE...
Anonymous ,Refer if this can help
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
hi Anonymous
For your case, I would suggst you add a calculate column by dax as below
Difference=FORMAT([Arrived]-[Planned],"HH:MM")https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
Regards,
Lin
hi Anonymous
For your case, I would suggst you add a calculate column by dax as below
Difference=FORMAT([Arrived]-[Planned],"HH:MM")https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
Regards,
Lin