Calcuate Age Based on a Specific Date

Jennifer Walsh 1 Reputation point
2022-11-10T22:15:04.407+00:00

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!

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,250 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dillon Silzer 54,731 Reputation points
    2022-11-10T22:30:24.2+00:00

    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.

    0 comments