topic Re: Calculate age based on Date of Birth in DAX Commands and Tips

Calculate age based on Date of Birth

Samiks95 — Wed, 19 Oct 2022 15:04:00 GMT

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.

Re: Calculate age based on Date of Birth

Anonymous — Wed, 19 Oct 2022 15:12:08 GMT

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.

Re: Calculate age based on Date of Birth

Samiks95 — Wed, 19 Oct 2022 15:30:44 GMT

Anonymous Thank you Luis!

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

Re: Calculate age based on Date of Birth

Anonymous — Wed, 19 Oct 2022 15:39:12 GMT

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")))

Re: Calculate age based on Date of Birth

Samiks95 — Wed, 19 Oct 2022 15:51:00 GMT

Anonymous Thank you so much. It worked.