perform math on dates from a mixed column

[genehiggins]

I have two tables in Power Bi that are related, People and Traits. 

People is just a litst of people

ID	Person
1	Person A
2	Person B

Traits has two columns, Trait Name and Trait value

Person ID	Trait Name	Trait Value
1	Height	72"
1	date of birth	1/1/1070
2	Home Town	Philadelphia
2	date of birth	2/2/1980

The only thing I care about for this visualization is the date of birth. I want to show a list of everyone who had a birthday in the last two weeks. Using a slicer I'm able to filter and get just a list of dates, but of course they are text and I can't perform any comparisons on them. 

Can this be done at the slicer level? Or am I going to figure out how to make a new table/measure/query that finds and isolates all the dates so that it can be formatted properly? 

Thanks!

[Anonymous]

Hi @genehiggins ,

I think you may need two tables. A copy of your Traits table, then a power query to change the Traits value data type to Date, then remove error will do what you want.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

read about DATEVALUE.  Make sure to use dates that Power BI recognizes.  1/1/1070 is not such a date.