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 All,
Im very new to power bi and basically I have a sharepoint list which is linked to power bi. One of columns in sharepoint list which is titled Time in a text format see screenshot below:
Can I convert this into hours in power BI?
Please help!
Solved! Go to Solution.
@Anonymous , if it is minutes
Hour = [time]/60
Or time format = time(0,[time],0)
@Anonymous , if it is minutes
Hour = [time]/60
Or time format = time(0,[time],0)
You can select "Add Column", and place formula:
Hours = DIVIDE([Time],60)
Or are you looking for something else?
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |