DAX Formula for Last refreshed

[cristianml]

Hi,

I need a DAX formula to use it with a visual in the model so END USERS can see the last time that the information was updated. 

Regards.

[Cmcmahan · Accepted solution]

So the easiest way to do this is via Power Query.

Stealing the idea from here

In your advanced editor, add a column to whatever table you want the refresh info from, and set the value equal to the current time in the advanced editor.  Display that in a card and you're good to go.

let
    Source = YourSource(Foo, Bar),
    #"Added Refresh Date" = Table.AddColumn(#"Source", "Refresh Date", 
        each DateTimeZone.FixedUtcNow(), type datetimezone)
in
    #"Added Refresh Date"