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.
How to convert date time to decimal so that the time can be presented on a trendline
I have this column (Completion Time):
I would like to see as a result: 5.58 for exampl if the completion time is 5:58 or some kind of alternative that allows me to use this field to presnet in a trendline completion time by month and calculate YTD completion time etc.
I tried using convert but I do not like the result I see:
Thanks!
thanks for feedback. Completion Time is just a column and not a measure and therefore power bi doesnt accept it in the formula..do you have another solution?
Hi @Anonymous ,
You could create a column as below:-
Column = round(FORMAT('Table (6)'[Completion tme],"HH")&"."&FORMAT('Table (6)'[Completion tme],"NN"),2)
BR,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi, I managed to create a new measure, however it looks like text. How can I convert it to double (round can not work as it is text):
@Anonymous Please create a column only. I have updated the code as per your table name. Please try this:-
Column =
ROUND (
FORMAT ( 'Daily Issues'[Completion_time], "HH" ) & "."
& FORMAT ( 'Daily Issues'[Completion_time], "NN" ),
2
)
Note:- I have considered the completion_time as column only.
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
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 |
---|---|
112 | |
100 | |
75 | |
65 | |
63 |
User | Count |
---|---|
140 | |
105 | |
102 | |
81 | |
67 |