Last Published Date

by

1. Create a blank query in Power Query Editor like so:

let
    Source = DateTime.LocalNow(),
    #"Converted to Table" = #table(1, {{Source}}),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Publish Date"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Publish Date", type datetime}})
in
    #"Changed Type"

2. Keep “Include in report refresh” unselected.

REFRESH.jpg

3. Create a Card visual to show “LastPublishedDate”.

last.PNG

4. Before publishing the report, you need to refresh the data of the “LastPublishedDate” table, not refresh the report. 

refresh data.jpg

Leave a Comment