Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
michellepace
Resolver III
Resolver III

Duration in minutes between two timestamps

‎06-16-2023 06:56 AM

Hi there. I've calculated the total minutes between two timestamps... but I guessed the formula. Is this the best way to go about doing it? In this particular case -- would it not make sense to rather calculate duration as a new column in my Table1 table?

 

michellepace_0-1686923750218.png

 

michellepace_0-1686924287866.png

 

Best wishes,

Michelle

Labels:
Message 1 of 2
225 Views
0
1 REPLY 1
tamerj1
Super User
Super User

‎06-16-2023 07:14 AM

Hi @michellepace 

Yes this is the best way. The calculated column would provide the same result if the data set is big then measure is more recommended 

Message 2 of 2
210 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All