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
This may help:
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.