98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Time Intelligence
Time Intelligence
Resolved · Low Priority · Version 2016
Wed 4 Dec 2019, 10:27Delegate Lesley said...
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
Thu 5 Dec 2019, 21:26Trainer Jens said...
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
Thu 12 Dec 2019: Automatically marked as resolved.
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Optimize Report PerformancePay attention to report performance by optimizing your data model and report design. Use the Performance Analyzer tool to identify bottlenecks in your report and improve loading times. Techniques such as using summarisation, avoiding unnecessary visuals, and optimizing DAX queries contribute to a faster and more responsive report. |
