Forum Discussion
Fix date format
Good afternoon.
I have a table with the start date, time and end date of equipment repairs.
I created a new column that shows the number of working hours that were spent on these repairs.
Now I need to create a graph that shows the total hours spent on each piece of equipment.
I created a measure, but the values being displayed are not as expected.
For example, I have a piece of equipment that has a total number of hours: 99:80. Which is not correct, it should be in this case, 100:20.
I put the images below, could anyone help me?
Thank you in advance.
2 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hello, lbendlin ,thanks for your concern about this issue.
And I would like to share some additional solutions below.
Hi,powertechbi .I am glad to help you.
Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
As lbendlin suggested, could you please provide some screenshots of the data or a pbix test file that doesn't contain sensitive data.Measure's calculations may be incorrect due to incorrect filtering conditions in the calculation environment. If you can provide the corresponding pbix file and show the relationship, it will help to solve your problem (to determine where the filtering error occurs).
You can share your pbix test file via the Github link
URL:How to Get Your Question Answered Quickly - Microsoft Fabric Community
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian
