Forum Discussion

ktt777's avatar
ktt777
Icon for Helper V rankHelper V
6 years ago
Solved

Calulate Age

Hi Everyone I have below table and i want to use DAX formula to calculate the age of people.  Name DOB  A 10/2/1988 B 2/5/1990 C 0 D     but for DOB data is Blank or "0", i...
DAX
  • Anonymous's avatar
    Anonymous
    6 years ago

    ktt777 ,

     

    Convert the Data Type to Date/Time.

     

    Use a Calculated Column

     

    Age =
    IF (NOT(ISBLANK('Table'[DOB ])),
    FORMAT(DATEDIFF('Table'[DOB ],Today(),YEAR),"##"),"No Data")
     
     
    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi ktt777 ,

     

     

    Create another calculated column.

     

    Age Group =
    IF('Table'[Age] <> "No Data",
    SWITCH(
    True(),

    VALUE('Table'[Age]) > 60 , "Above 60",
    VALUE('Table'[Age]) <=60 && VALUE('Table'[Age]) >30, "31-60",
    VALUE('Table'[Age])<=30 && VALUE('Table'[Age]) >18 ,"19-30",
    VALUE( 'Table'[Age]) <=18 , "Below 18"
    ),
    "No Data")
     
     
     
     

    Regards,
    Harsh Nathani

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

ktt777 ,

 

Convert the Data Type to Date/Time.

 

Use a Calculated Column

 

Age =
IF (NOT(ISBLANK('Table'[DOB ])),
FORMAT(DATEDIFF('Table'[DOB ],Today(),YEAR),"##"),"No Data")
 
 
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ktt777 ,

 

 

Create another calculated column.

 

Age Group =
IF('Table'[Age] <> "No Data",
SWITCH(
True(),

VALUE('Table'[Age]) > 60 , "Above 60",
VALUE('Table'[Age]) <=60 && VALUE('Table'[Age]) >30, "31-60",
VALUE('Table'[Age])<=30 && VALUE('Table'[Age]) >18 ,"19-30",
VALUE( 'Table'[Age]) <=18 , "Below 18"
),
"No Data")
 
 
 
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)