Forum Discussion
Solved
Time format export data from hours to decimal
I have an interesting query I am working in time and invoice management web site called workflow max. To get data from the web site I export reports in csv format. For small time entrie...
In query editor. Select the column and split it by deliminator
You get two columns. 1 is hours, 1 is mins
New column = hours + (mins/60) = decimal number and works with values over 24 hours.
KISS
In Dax you also have a format function :
refer : https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings