Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Histogram using birthday dates

Hello, I have a column of dates (birthdays), and I want to create a histogram showing counts within an age range, for example   01-02 03-05 06-12 13-17 18-21 22-30 31-40 41-50 51-65 66-75...
Need Help
  • jahida's avatar
    jahida
    10 years ago

    Oh yeah my bad, forgot that was illegal. How's:

     

    CountDOB = COUNTROWS(FILTER(Sheet1, DATEDIFF(Sheet1[DOB], TODAY(), YEAR) >= MIN('HistAges'[AgeLowerBound]) && DATEDIFF(Sheet1[DOB], TODAY(), YEAR) <= MAX('HistAges'[AgeUpperBound'])))

jahida's avatar
jahida
Impactful Individual
10 years ago

Oh yeah my bad, forgot that was illegal. How's:

 

CountDOB = COUNTROWS(FILTER(Sheet1, DATEDIFF(Sheet1[DOB], TODAY(), YEAR) >= MIN('HistAges'[AgeLowerBound]) && DATEDIFF(Sheet1[DOB], TODAY(), YEAR) <= MAX('HistAges'[AgeUpperBound'])))

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Amazing! jahida

 

You're the best, thank you.