Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
In a column I have values
8.00.00
2.30.00
4.45.00
which are Time Type. I need to change them to Decimal Numbers so they would be
8,00
2,50
4,75
How can I achieve this?
Solved! Go to Solution.
Hi,
According to your description, i create a sample like this:
After Apply&Close, it shows:
Then try this calculated column:
TimeDuration = 'Table'[Custom]*24
The result shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto
Hi,
According to your description, i create a sample like this:
After Apply&Close, it shows:
Then try this calculated column:
TimeDuration = 'Table'[Custom]*24
The result shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto
@Finnair ,Try like a new column
New column = hour([Time]) + Minute([Time])/60
No, my time values are in fact durations, so your suggestion is not ok. Thanks anyway.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.