Forum Discussion
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
- austinsenseImpactful 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
- ZELLAOUIRegular Visitor
Thanks a lot !
Is it possible to dipslay it a little bit bigger and cutomize it inside my dashboard ?
Thanks in advance,
Zakaria.
- Greg_DecklerCommunity Champion
You could create a query or add a calculated column to one of your queries that is essentially DateTime.LocalNow()
https://msdn.microsoft.com/en-us/library/mt253492.aspx