topic Re: DATEDIFF, Calculate Age, Issue for Age less than one Year . in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DATEDIFF-Calculate-Age-Issue-for-Age-less-than-one-Year/m-p/3417153#M129318 <P>due to it bein 8 months , it will round up hence the one&nbsp;</P> Wed, 06 Sep 2023 07:45:04 GMT eliasayyy 2023-09-06T07:45:04Z DATEDIFF, Calculate Age, Issue for Age less than one Year . https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DATEDIFF-Calculate-Age-Issue-for-Age-less-than-one-Year/m-p/3417048#M129314 <P>Hi Dears ,&nbsp;</P><P>&nbsp;</P><P>I'm trying to calculate the age of the patient's list (what his/her Age was on the exam Date ) , using DAX&nbsp;<BR />DOB = birthdate<BR />ExamDate = ExamDate</P><P>&nbsp;</P><P>so the code was&nbsp;</P><DIV><DIV><SPAN>DATEDIFF</SPAN><SPAN>('TableName'[DOB],[ExamDate],YEAR)<BR /></SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>So, I have a case that&nbsp;</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>DOB= 20-DEC-2022</SPAN></DIV><DIV><SPAN>ExamDate =&nbsp;02-AUG-2023<BR /><BR /></SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>The expected result is = 0 because this age must be 8 months, but it returns 1 instead&nbsp;</SPAN></DIV><DIV><SPAN>Does anyone have a clue why and how to solve this?&nbsp;</SPAN></DIV></DIV> Wed, 06 Sep 2023 06:49:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DATEDIFF-Calculate-Age-Issue-for-Age-less-than-one-Year/m-p/3417048#M129314 yalomari 2023-09-06T06:49:13Z Re: DATEDIFF, Calculate Age, Issue for Age less than one Year . https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DATEDIFF-Calculate-Age-Issue-for-Age-less-than-one-Year/m-p/3417153#M129318 <P>due to it bein 8 months , it will round up hence the one&nbsp;</P> Wed, 06 Sep 2023 07:45:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DATEDIFF-Calculate-Age-Issue-for-Age-less-than-one-Year/m-p/3417153#M129318 eliasayyy 2023-09-06T07:45:04Z