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 ,
my column data is in hh:mm:ss format for ex.
12:23:34
08:23:12
i want it to be converted into decimal value like for first value it should show me 12.23 hours
and second should show me 8.23 hours
Please suggest me some ways to convert it . I have tried all dax formulas best of my knowldege. i amanged to get it converted it into seconds. by=ut i require in this format
Solved! Go to Solution.
Hi @Anonymous
You may create a new column to get the value.For example:
Column 2 = HOUR([Column])+MINUTE([Column])/60+SECOND([Column])/60/60
Regards,
My example :( I have Vehicle Hours in Seconds to convert that into hours & decimal time.
Trip Hours:
Hi @Anonymous
You may create a new column to get the value.For example:
Column 2 = HOUR([Column])+MINUTE([Column])/60+SECOND([Column])/60/60
Regards,
Hi Preetam,
Did you try converting the data type from the modeling field? see below my Before and After outputs
Before:
After:
Hi,
My column which contains data in hh:mm:ss format resulted from substracting two other columns start time and end time so it is a calculated column.Now ,suggest does this method still works ?
Please try these steps.
1. Change the data type of your calculated column to Decimal.
2. Create a new column using this formula :
Decimal Duration = TimeConversion[Duration]*24
ok. I did not know what was your scenario.
May be this post helps you.
Thanks,
Tejaswi
Split it into three columns using : as a delimiter, then make a new column that's hours + (minutes/100)
Is there any nested dax formula that work?
Also why need to divide minutes by 100 not 60?
I don't know about a DAX solution, and I'm dividing by 100 as that's what'd give you the result you wanted
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |