Calculate age based on Date of Birth

[Samiks95]

Hello,

I have a column Date of Birth. And now, I want to calculate Age based on Date of Birth. I also want to do the age grouping.

[Samiks95 · Accepted solution]

@Anonymous Thank you Luis! 

I want to create a age range based on the age. Similar to the attached pic.

[Anonymous]

Hi @Samiks95,

You can create this column:

Age = DATEDIFF([Date of Birth],TODAY(),YEAR)

And i dont understand about the age grouping what do you want to do.

[Samiks95 · Accepted solution]

@Anonymous Thank you Luis! 

I want to create a age range based on the age. Similar to the attached pic.

[Anonymous · Accepted solution]

Ok, try with this, change "Table (4)"  with the name of the table where you have the column Age

Range = IF(AND('Table (4)'[Age]>=0,'Table (4)'[Age]<=16),"Child",IF(AND('Table (4)'[Age]>=17,'Table (4)'[Age]<=30),"Young Adults",IF(AND('Table (4)'[Age]>=31,'Table (4)'[Age]<=45),"Middle-aged Adults","Old-aged Adults")))

[Samiks95]

@Anonymous Thank you so much. It worked.