Imagine we want to keep track if we have reached a maximum/Record value using Power BI 'alerts's.
If the threshold value was dynamic and not static, we could always evaluate if, at the current date, we have reached a new record, analysing historical data from the past to establish the threshold to consider.
Would that be easy to implement?
Kind regards,
João