cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
msommerf Regular Visitor
Regular Visitor

Calculating age from a date and time

Hi am fairly new to BI & DAX and am struggling to do what I think should be very simple.

 

I have the following measure:

Selected Value = DATEVALUE(Format(SELECTEDVALUE('Year Analysis'[EOY Date]),"DD/MM/YYYY"))
 
I have a column full of dates in my table which are birth dates
 
I simply want to calculate the age for each person (SelectedValue date - Birthdate)
I have tried to create a new column using:
 
Age = Datediff ([Selected Value],'fleet list'[Dob],year)
 
But I get the error message: Cannot Convert Value " of Type Text to Date
 
Both the Dob Column and my measure are of a type Date.
 
Can anyone help?
 
Kind regards
Mark.
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Calculating age from a date and time

@msommerf  - One potential issue:

The SELECTEDVALUE function only returns a value if there is a single value in the context. To make sure you only get a single value, you could use MAX instead.

Hope this helps,

Nathan

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Calculating age from a date and time

@msommerf  - One potential issue:

The SELECTEDVALUE function only returns a value if there is a single value in the context. To make sure you only get a single value, you could use MAX instead.

Hope this helps,

Nathan

View solution in original post

msommerf Regular Visitor
Regular Visitor

Re: Calculating age from a date and time

Many thanks Nathan. This worked a treat!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)