Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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.
read about DATEVALUE. Make sure to use dates that Power BI recognizes. 1/1/1070 is not such a date.
User | Count |
---|---|
93 | |
83 | |
77 | |
70 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |