Showing results for 
Search instead for 
Did you mean: 
Regular Visitor


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



Super User IV
Super User IV

This may help:



@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors