Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
If would like to add a visual alert (just text in red for example) when the "last refresh date" (which is a measure) is before current date minus one. This so everyone directly sees the report is not last refreshed the previous night. Can I do this with a simple measure?
Thanks in advance
Solved! Go to Solution.
Please see this video for several examples of data quality checks following a dataset refresh. But you can compare the max date in your fact table (or refresh date) with a measure like this (the ALL is used to avoid any filters from slicers on your page).
Days Since Refresh = CALCULATE(MAX(Table[TransactionDate]), ALL()) - TODAY()
https://www.youtube.com/watch?v=n8qGP2kiZHo&t=478s
Pat
Please see this video for several examples of data quality checks following a dataset refresh. But you can compare the max date in your fact table (or refresh date) with a measure like this (the ALL is used to avoid any filters from slicers on your page).
Days Since Refresh = CALCULATE(MAX(Table[TransactionDate]), ALL()) - TODAY()
https://www.youtube.com/watch?v=n8qGP2kiZHo&t=478s
Pat
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
10 | |
7 |