Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Leonard Levine]

Hi,

I have data with name, date of service  and date of birth (see below). An individual can have multiple dates of service in a given year.  I am trying to first find earliest date of service for each name in each  year of service. Second I wish to calculate  age (Date of Service- Date of Birth .  Then if less than 19 years of age classify as child, otherwise adult.

Below is a graphic of what I am trying to achieve.  Thanks in advance!!!

[Jonathan CHANAL]

Hello,

Here is a solution. I did not add the age but you can do it in Power Query if necessary. You said “Less than 19” but in the screenshot, it’s less or equal I think, you have to modify it in Power Query.

Have a nice day,

——————————
Jonathan CHANAL
Power BI Consultant/Formateur
MCSA Power BI & Excel
——————————
——————————————-