Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a Data on Google sheet which is in Duration Format and when I link this sheet with Power Bi Data Source it is reflecting in Time Format AM/PM
I would really appreciate if anyone can please me show the same duration as it is in my data sheet.
PFB Screenshot for your refrenec.
Thanks.
Solved! Go to Solution.
@Shayz2402 you can PM me and we could do a quick zoom to look together if you want. Hard to see from the sceenshots
@ this is the code:
Five 9 Total =
VAR _value = SUM(Sheet7[Five 9 Login TIme])
VAR _hours = DATEDIFF(DATE(1899,12,30),_value,DAY) * 24 + HOUR(_value)
VAR _minutes = MINUTE(_value)
VAR _seconds = SECOND(_value)
RETURN
_hours & ":" & _minutes & ":" & _seconds
Request everyone to please Help me.
@ this is the code:
Five 9 Total =
VAR _value = SUM(Sheet7[Five 9 Login TIme])
VAR _hours = DATEDIFF(DATE(1899,12,30),_value,DAY) * 24 + HOUR(_value)
VAR _minutes = MINUTE(_value)
VAR _seconds = SECOND(_value)
RETURN
_hours & ":" & _minutes & ":" & _seconds
Thanks a lots @SpartaBI You are an very knowlagable and amazing Person. You safe my day and also it means a lot to me.
Thanks a Lot and Much appreciated your help and support.
Looking forward to work with you.
@Shayz2402 you can PM me and we could do a quick zoom to look together if you want. Hard to see from the sceenshots
Hi @SpartaBI Thanks for your reply. Can you please confirm your availablity for today to connect on Zoom.
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |