Alert measure if last refresh date is before current date minus one

[JC2022]

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 

[ppm1 · Accepted 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