Forum Discussion

nadavfishman's avatar
nadavfishman
Regular Visitor
9 years ago

duration

hey you all..

im using pbi in direct query mode to my sql 2008 r2 server.

 

maybe someone have an idea how can i calculate a duration between the first row in my db and now().

my DateAndtime field is in dec number and i converted it to dated by divide in 1440

 

now i want to know the duration from the first row in my table to the last time dataset refreshed.

 

thanks in advance