How to keep the age correct over the years

[jochendecraene]

Hi all

I got a table with some cliënts and their age, adress, ...

ex; Jones Johnson, age 56, ....

Can I create a measure so that I can keep this age of 56 correct over the years?

thx

[amitchandak]

@jochendecraene , If you have a Date of birth, even a column can do that

new column

age  = datediff([dob], today(), year)

new measure

age  = datediff(min(Table[dob]), today(), year)

[jochendecraene]

The problem is that the dataset contains no DOB, they only give me the age. They don't register DOB ...

[v-deddai1-msft · Accepted solution]

Hi @jochendecraene ,

You can use the following column:

actualage  = datediff(DATE(2021,1,1), today(), year)+Table[age]

Or measure:

actualage  = datediff(DATE(2021,1,1), today(), year)+MAX(Table[age])

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai