Forum Discussion

Sam88's avatar
Sam88
Frequent Visitor
6 years ago
Solved

TODAY() and NOW() functions in Calculated Columns

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)...

 

ParameterValue
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.

Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    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

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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