Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
once we group one cell and having multiable duration and SUM of them is equal more than 24 hours as duration is not appeared all total example 20:10:10 (HH:MM:SS) + 10:10:05 it should shows as 30:20:15 ..
Any help here ?
Solved! Go to Solution.
Hi @amerjaroudi
You need to treat travel time as a duration in Power Query then bring that into PBI Desktop where it will be a decimal.
You can then write a measure to display your travel time in a friendly H:M:S format - see this solution for code and an explanation
Solved: Converting decimal hours to friendly format (D:H:M... - Microsoft Power BI Community
Leaving the travel time as decimal in PBI means you can do maths with it.
You can uplaod your PBIX file to OneDrive or Dropbox and then link to it from here.
Regards
Phil
Proud to be a Super User!
Hi @amerjaroudi
You need to treat travel time as a duration in Power Query then bring that into PBI Desktop where it will be a decimal.
You can then write a measure to display your travel time in a friendly H:M:S format - see this solution for code and an explanation
Solved: Converting decimal hours to friendly format (D:H:M... - Microsoft Power BI Community
Leaving the travel time as decimal in PBI means you can do maths with it.
You can uplaod your PBIX file to OneDrive or Dropbox and then link to it from here.
Regards
Phil
Proud to be a Super User!
If your column is already a duration, you can add a custom column with
= Duration.TotalHours([DurationColumn]
If your column is a Time, you can add a custom column with
= Duration.TotalHours([Time]-#time(0,0,0))
Either way, you'll end up with hours as a decimal that you can then add up for analysis. You could use the other Duration.Totalxxx functions if you don't want hours.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @amerjaroudi
Please always supply sample data so we don't have to guess what you are doing.
I presume you are talking about Durations in Power Query? But by the format you are using you may be using Times rather than actual Durations?
A Duration in Power Query is actually a decimal number describing whole days e.g. 1.25 is 1 day and 8 hours.
When you bring these durations into Power BI (the Data Model) you'll see them as decimals.
So to add durations you first must store them as durations, and adding them is just as simple as adding decimals.
Please provide some sample data so I can see what you are actually doing.
Regards
Phil
Proud to be a Super User!
Thanks for your reply ..
I made time differance between two columns "Depart" and "Arrival" and called "Travel_Time" as duration in (Query Editor) then I choose "Region" coulmn to table visualization and didn`t find (sum of travel_time) only count found it,, I make new measure of Travel time "
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |