Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to sum duration with time

Hi all,

 

I would like to sum task duration with begining Date/Hours of the same task.

 

Exemple:

Begining date                           Task duration (h)         Task estimated end

22/04/2020 13:30                            30                          23/04/2020 14:30

 

Anyone have idea in order to calculate column "Task estimated end" from my exemple ?

 

Thank you !

1 ACCEPTED SOLUTION

Hi  @Anonymous ,

 

Go to query editor> add column>custom column;

Then put the below expression inside:

 

Custom=[datetime]+#duration(0,[Duration],0,0)

 

Annotation 2020-05-28 140941.png

Finally you will see:

Annotation 2020-05-28 141250.png

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , try

Task estimated end =[Begining date] + time([Task duration (h)],0,0)

 

Anonymous
Not applicable

Hi, thank you for quick answer.

 

I tried but it seems that works only when "Task Duration" it's smaller than 24 hours.

Hi  @Anonymous ,

 

Go to query editor> add column>custom column;

Then put the below expression inside:

 

Custom=[datetime]+#duration(0,[Duration],0,0)

 

Annotation 2020-05-28 140941.png

Finally you will see:

Annotation 2020-05-28 141250.png

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.