Forum Discussion
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
Super User
Super UserPlease 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
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 |
- lbendlin
Not clear how you get from the sample data to the expected result . Can you please explain?