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.

  • 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

3 Replies

  • austinsense's avatar
    austinsense
    Impactful Individual

    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

    • ZELLAOUI's avatar
      ZELLAOUI
      Regular Visitor

      Thanks a lot !

       

      Is it possible to dipslay it a little bit bigger and cutomize it inside my dashboard ? 

       

      Thanks in advance, 

      Zakaria.