Calcuate Age Based on a Specific Date

Jennifer Walsh 1 Reputation point


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!

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
26,830 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dillon Silzer 39,546 Reputation points

    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 and they will gladly assist with more expertise.


    If this is helpful please accept answer.

    0 comments No comments