Forum Discussion

Reine's avatar
Reine
Helper IV
7 years ago
Solved

DATEDIFF with IF statement?

Hello :) I have made a column in my report table to calculate the age from the date of birth using DATEDIFF. Upon seeing the data, I realize that I need to add something so that if the age is less th...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    7 years ago

    My guess is you are getting converion errors with the IF?  Try something like this:

    Age =
VAR AgeCalc =
    DATEDIFF ( [LaddersT.PersonT(PersonID).BirthDate], TODAY (), YEAR )
RETURN
    IF ( AgeCalc < 5, "Unknown", FORMAT ( AgeCalc, "00" ) )
jdbuchanan71's avatar
jdbuchanan71
Super User
7 years ago

My guess is you are getting converion errors with the IF?  Try something like this:

Age =
VAR AgeCalc =
    DATEDIFF ( [LaddersT.PersonT(PersonID).BirthDate], TODAY (), YEAR )
RETURN
    IF ( AgeCalc < 5, "Unknown", FORMAT ( AgeCalc, "00" ) )
  • Reine's avatar
    Reine
    Helper IV
    7 years ago

    Woohoo!  this works perfectly - thank you so much :)  I am new to Power BI as well as DAX so it's all a bit foreign to me still.  I'll study this to better understand what you've done.  I really appreciate your help - I spent hours trying to figure it out.  ugh

  • Reine's avatar
    Reine
    Helper IV
    7 years ago

    Hi - now that I have patient ages, I need to be able to pull all patients in a given time period and show how many people there are in each age group - age groups being <18, 18-39, 40-59, 60+.

     

    Can you help me figure that out as well?  Sorry - I wasn't thinking about this yesterday or I would have asked for both at the same time.

     

    Thank you :)