duration

[nadavfishman]

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

[Greg_Deckler]

This may help:

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486