Lesley has attended:
Power BI Modelling, Visualisation and Publishing course
Power BI DAX course
Time Intelligence
Hi, I have some data which reports the number of hours taken to complete a task. Some of the hours go over 24hours and I am struggling to get the information into Power BI. Most of the times I am reporting on are in excess of 24 hours and I have got the format correct in Excel but this is not working in BI. Can you please help. I have tried changing the data type in Power Query to duration/time and text but this just brings up an error. Thank you
RE: Time Intelligence
Hi Lesley,
Thank you for the forum question.
It is in Power Bi a very difficult task. You have a simple question and I cannot understand, why Microsoft does not have a simple solution. But there is no simple solution.
I have managed to change time to duration. In the query editor I changed the column with the time to time format. What the query did was to give me a date space and the time. On the Transform tab I clicked Split Column and I used the space delimiter. Then I got the time in one column and the date in one column. Now the query accepted the Duration formatting.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
