Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Summarize Table to show total children and adults per year

    Silver Contributor
    Posted 16 days ago
    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!!!
    image.png


  • 2.  RE: Summarize Table to show total children and adults per year

    Top Contributor
    Posted 14 days ago
      |   view attached
    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
    ------------------------------

    Attachment(s)

    pbix
    Summarize Table.pbix   72 KB 1 version