Where the data is refreshed? (custom column vs calculated column)

[AlejandroPCar]

Hi!

I have a question here. I have a calculated column who makes ages based on the birthdate column.

But I'm not sure where the column everyday calculated the age again: If I do in the Query Editor or with DAX in data view? (or maybe it doesn't matter or even no one of both of them).

And if it is necessary to refresh the report or automatically every day the column is calculated again?

Thanks for your help.

[Greg_Deckler · Accepted solution]

If you do this as a custom column in M (Power Query) or in a DAX calculated column, the column is re-calculated at the time of data refresh only.