Forum Discussion

ZELLAOUI's avatar
ZELLAOUI
Regular Visitor
10 years ago
Solved

Refresh Date (Manual refresh)

Hi everyone,  I have a dashboard on power BI desktop that I refresh manually twice a day.  I would like to display the refresh date on my dashboard.     Is it possible ?    Thanks. Zakaria.
  • austinsense's avatar
    10 years ago

    There are three options:

     

    There are two ways to write a measure that returns the most recent date / processing date in your data model.

     

    1. If you have a data(transaction) table

    Most Recent Transaction = CALCULATE( MAX(Transactions[Date]), ALL(Transactions) )

    2. If you have a calendar table - there's a two step process

     

         A. Create a calculated column

    Processing Date Flag = IF( Calendar[Date] = Now(), 1, 0 )

         B. Create a measure

     

    Processing Date = CALCULATE( MAX(Calendar[Date]), Calendar[Processing Date Flag] = 1 )

     

     

    The third way is a lot easier. You can edit a tile on your dashboard to show the last refresh date.  This is better in a way because each tile will show the right date for the underlying data set

     

    3. Click on the "..." on the top right of a dashboard tile.  This opens up a menu click on the pencil icon which will bring up a properties menu.  Check the box to turn on last refresh date.  The only downside is you'll have to go and do this for every tile on your dashboard.

     

    Editing a TileTurning on Last Refresh Date