Forum Discussion
Borjaveiga
2 years agoRegular Visitor
Problems witha time format measure
Good afternoon to all, Maybe somene could help me out with this problem I am finding. I created a measure to show time as such 1:02:00 using this DAX Hours = FORMAT(time(0,sum('Descarga...
lbendlin
2 years agoSuper User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
- Borjaveiga2 years agoRegular Visitor
the column that the meassure refers to is registered_time_mins and looks likes this:
registered_time_mins expected_time expected_time_mins 9120 168h 10080 10260 168h 10080 10731 168h 10080 7500 160h 9600 7680 168h 10080 9600 160h 9600 - lbendlin2 years agoSuper User
Not clear how you get from the sample data to the expected result . Can you please explain?