Forum Discussion
Refresh Date (Manual refresh)
- 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
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
Thanks a lot !
Is it possible to dipslay it a little bit bigger and cutomize it inside my dashboard ?
Thanks in advance,
Zakaria.