Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All...
Help needed one more time.
I have two Time columns in my table.I want to find the difference of time and append this duration with some text.
time1 time 2 remarks
02:30:00 03:00:00 duration is 30 Minutes
21:00:00 22:30:00 duration is 1hour30Minutes
Can someone please help.Thanks.
Solved! Go to Solution.
Hi @Dain,
Try out this formula please.
remarks = VAR minutes = DATEDIFF ( [time1], [time2], MINUTE ) VAR h = INT ( minutes / 60 ) VAR m = MOD ( minutes, 60 ) RETURN IF ( h = 0, "Duration is " & m & " Minutes", "Duration is " & h & " hours " & m & " Minutes" )
Best Regards,
Dale
Hi @Dain,
Try out this formula please.
remarks = VAR minutes = DATEDIFF ( [time1], [time2], MINUTE ) VAR h = INT ( minutes / 60 ) VAR m = MOD ( minutes, 60 ) RETURN IF ( h = 0, "Duration is " & m & " Minutes", "Duration is " & h & " hours " & m & " Minutes" )
Best Regards,
Dale
Thank You so much for the Answer!.
I am struggling to implement another logic.Could you please have a look on it.
I have a date slicer with start and end dates.I want to find the first working day of month for each months tat comes in that slicer start n end dates.For each first working day,i want to execute a specific logic.How can i do it dynamically
Hi @Dain,
My pleasure. Seems it's a new topic. I would suggest you create a new thread in this forum. If you can post a sample, that would be helpful for the community to work out an answer.
Best Regards,
Dale
Posted as new.Kindly check
User | Count |
---|---|
102 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |