Date only update when refresh

Hi Anonymous,

Please follow the below steps to create a new table we use it to get the Last Refreshed Date

- Open Transform Data

- Click on New Source and choose Blank Query

- Click on Advanced Editor and insert the below script:

let
    Source = #table(type table[Date Last Refreshed = datetime], {{DateTime.LocalNow()}})
in
    Source

Those steps will create a table with 1 value which is the Last Refreshed Date, change the type of this column to Date

now in your measure, change the below formula

VAR _today = TODAY()

To

VAR _today = MAX('LastRefreshedTable'[Date])

This field will only refresh when you Refresh the table "LastRefreshedTable"