TODAY() and NOW() functions in Calculated Columns

[Sam88]

Hi!

I've a doubt.
In a Report I've created a Parameter Table that a contains a reference date calculated with Today() function (or Now(), it's the same)...

Parameter	Value
Ref. Date	" Value = TODAY()"

Then I've used this value in some other measures.
I would like to know when "Value" field is updated because I thought that it would be calculated when refresh data, but instead every time I reopen the pbix it already contains new value.

P.s. I know that I can use as this parameter an M calculated column with Time.Local.Now(), or maybe a parameter if I need to change manually directly in powerbi service with another specific date in some situations.

thanks,

best regards.

[v-yuta-msft · Accepted solution]

@Sam88 ,

The NOW() and TODAY() function will always return the real time/date, they don't depend on the data in your model. Calculate columns and measures will be changed once the data table is refreshed in your data model(suppose in import mode).

Regards,

Jimmy Tao

[jdbuchanan71]

@Sam88 

Calculated columns are refreshed whenever the table is processed.  In PowerBI desktop that is when you open the the file but when you publish to the service it happens when the model is refreshed.

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/