Forum Discussion
perform math on dates from a mixed column
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!
2 Replies
- lbendlin
Super User
read about DATEVALUE. Make sure to use dates that Power BI recognizes. 1/1/1070 is not such a date.
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 ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
