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...
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
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |