Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Create new integer column for text

Hi, I have this set of data, now i would like to derive a new column call age: For YOB type is text, so im encounter problem to convert it to number.  For new column Age it should be derive from '2...
Tutorial Requests
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Anonymous 

    you can also try to use DAX to get the new column

     

    AGE = IFERROR(2024-'Table'[YOB],0)
    OR 
    AGE = IFERROR(YEAR(TODAY())-'Table'[YOB],0)
     
     
Anonymous's avatar
Anonymous
Not applicable
2 years ago

thank you!

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

you are welcome