Hello
In a table I have a column with a REFRESH-DATE and another COLOR column whose value is calculated with a DAX formula.
The COLOR column depends on whether the DATE-REFRESH column is equal to TODAY or not:
COLOR = IF(UltimoDato[Fecha]=TODAY(),"black","red")
What's the matter? The formula is not calculated if I do not do a REFRESH.
You might think "If you don't do a REFREESH the data doesn't change, why recalculate a formula then if you don't do a REFREESH?". Very easy, if in the formula we put a value that changes over time, such as TODAY(), the result of the formula can change without having to do a REFRESH. The result changes if the TODAY() value changes, which happens every day as we all know 🙂
Example:
- We are at 2023-01-23, I assign the value 2023-01-23 to the column DATE-REFRESH
- In this case the column COLOR = "black", because REFRESH-DATE coincides with TODAY
- We let a day pass
- We are at 2023-01-24, we return to the POWER-BI report
- The value of REFRESH-DATE is still 2023-01-23, which is different from TODAY, however COLOR = "black", when what I hope is that it is "red"
- For COLOR to be recalculated I have to do a REFRESH, but I want the formula to be recalculated without having to do said refresh
What do I want to achieve with this?
When I consult data from a database I also update a REFRESH-DATE, so I always know if the automatic refresh is working. If I look at the report and see that the REFRESH-DATE is not today's then I know that something has gone wrong and that the data are old.
In order to better detect that case, I would like the background of the card where I show DATE-REFRESH to change to RED, but since the formula is not recalculated if REFRESH is not done, the color does not change.
Any ideas?
Thank you
Amadeo
