converting difference between two dates into number of days

[rashid0146]

Hi All

I have two Columns. Date of Birth and Current Date. I have applied a simple formula in 3rd Column Age=[Current date]-[Date of Birth] I found the result in Date format. Now I want to convert 3rd column in number of days or number of years

Basically I want to calculate age in years in 3rd Column of 4th Column using the 3rd Column Information.

Best Regards

Rashid Anwar

[hemantsingh · Accepted solution]

Hi @rashid0146,

 you can use datediff function in 3rd column only for finding the difference in years.

DATEDIFF(dateofbirth, currentdate, year)

Reagrds 

[Gnanasekar · Accepted solution]

Hi @rashid0146

can you below dax function to calculate difference between two date

Difference = DATEDIFF(<start_date>, <end_date>, <interval>)

For your case, use

Days = DATEDIFF(tablename[Date of birth], Today(),Days)

you will get days here.

By

Gnanasekar

[hemantsingh · Accepted solution]

Hi @rashid0146,

 you can use datediff function in 3rd column only for finding the difference in years.

DATEDIFF(dateofbirth, currentdate, year)

Reagrds