Last Processed

[paivers]

Is it possible to access a table's "Last Processed" date/time in a measure. I'd like to show the currency of the data on a report. - Pete

 

[powerpivotpro]

Try this post: Add a

That returns the latest "data" date. If you truly want "today," try the TODAY() function instead in a measure. That should only recalc on refresh (or when you change a formula).

 

[powerpivotpro]

Not sure why the post link above got shortened like it did. Here it is again:

Add a last refreshed date

 

[paivers]

Thanks Rob. I like the lastdate() approach as it catches failures in upstream data warehouse ETL's by showing the last transaction. Thank you.