date not getting refreshed after scheduled refresh

All forum topics
Previous Topic
Next Topic

I have a transaction table that has two date columns: transaction_date and days_since_transaction(current date - transaction_date). The values in days_since_transaction column arent getting updated with the scheduled refresh in the power bi service. The formula i'm using is: duration.days((datetimezone.utcnow())-[transaction_date].

Any idea how to resolve this ?