Forum Discussion

Pbiuserr's avatar
Pbiuserr
Post Prodigy
4 years ago
Solved

Calculate age in PowerQuery - null dates

Hello.

I would liek to calculate age in PowerQuery but some rows doesnt have the data in the column, therefore I'd like it to have age 0. Tried that (convert value) but it keeps giving me error. I am calculting age using ribbon in Transform data

Need Help
  • Saap's avatar
    Saap
    4 years ago

    Hi Pbiuserr 

    I assume that you have a column with birth dates. If yes, then you can create custom column like this:


    Remember to change the birth date data type to datetime and after adding the age column change its type to whole/decimal number.

     

     

2 Replies

  • Saap's avatar
    Saap
    Resolver III
    4 years ago

    Hi Pbiuserr 

    I assume that you have a column with birth dates. If yes, then you can create custom column like this:


    Remember to change the birth date data type to datetime and after adding the age column change its type to whole/decimal number.

     

     

  • James-Harpin's avatar
    James-Harpin
    Resolver IV
    4 years ago

    Hi Pbiuserr 

    Would you be able to send an example of your data?

    I would recommend creating a calculated column using an IF statment for Blank values to show 0