Forum Discussion

Post Prodigy

7 years ago

Solved

DAX Formula for Last refreshed

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.

General Comment

Interesting Links

Tips and Tricks

Tutorial Requests

Cmcmahan
7 years ago
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"

Resident Rockstar

7 years ago

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"

Related content