Calcuate Age Based on a Specific Date

Question

Hello,

I have a list of customers and their date of birth. How can I get a column added in PowerBI which shows their age as of a specific future date, such as 1/1/2023, or 1/15/2023?

For example, "today" is 11/10/2022 and the customer's DOB is 1/5/2000. On 1/1/2023 the customer will be 22 years of age, but on 1/16/2023 they will be 23 years of age.

The future date would be the same date for all customers.

Thank you for any feedback!

Answer 1

Hi @Jennifer Walsh

Unfortunately Power BI is not supported on this forum at this time. It is best that you reach out to PowerBI experts at https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services and they will gladly assist with more expertise.

----------------------------------------------

If this is helpful please accept answer.