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.
I have a table with traveling data called Travel Time and I want to add it together,
TravelTime|HH:MM
7.30
2.20
The total expected time (HH: MM) is 7.30+2.20=9.50
Thanks in advance
Solved! Go to Solution.
Hi @PowerBIData
You can calculate the sum for the column[TravelTime|HH:MM] ,and then convert the value(Decimal number) to time format .
For example :
Column = FORMAT(TIME(TRUNC('Table'[TravelTime|HH:MM],0),('Table'[TravelTime|HH:MM]-TRUNC('Table'[TravelTime|HH:MM],0))*60,0),"long time")
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @PowerBIData
You can calculate the sum for the column[TravelTime|HH:MM] ,and then convert the value(Decimal number) to time format .
For example :
Column = FORMAT(TIME(TRUNC('Table'[TravelTime|HH:MM],0),('Table'[TravelTime|HH:MM]-TRUNC('Table'[TravelTime|HH:MM],0))*60,0),"long time")
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @PowerBIData
I created an example, check it out.
https://drive.google.com/drive/folders/1a9P05JCCETmep3vMDdVrixXhY-uK4gp-?usp=sharing
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
@PowerBIData
If you need to convert it in Power Query: add the following Custom Column and change data type to Time.
#duration( 0, Number.IntegerDivide([Time],1) , Number.Mod([Time],1)*60, 0 )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
The simplest way to do that is to convert your time columns to decimal number, make your expression, and then use a custom format string to display it as hh:mm (use hh:nn).
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |