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! Would you know the format needed to get the actual days based on a duration value please? The raw data is a number / decimal but everytime I transform / format it using a measure to DD:HH:MM it shows as 30 or 31: Hours: Minutes when days are 0.
It should read 0 days if there is no days involved and show 00:HH:MM. Hope you can help! thanks!
@PhineG , Make sure your decimal is in the days. If it is hours divide it by 24 and so on
= time(0,0,0) + [number in days]
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 | |
76 | |
64 | |
63 |
User | Count |
---|---|
140 | |
105 | |
102 | |
81 | |
67 |