Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a data table with duplicated users id with different information and different dates.
What would be the best comparison charts to compare for those data.
This is the example data for some users.
User ID | Date | Score | Education | Ride | Location |
1 | 1/1/2020 | 50 | High School | Bicycle | Urban |
1 | 1/1/2022 | 70 | Under Graduate | Bicycle | Rural |
2 | 1/1/2020 | 40 | High School | Bike | Rural |
2 | 1/1/2022 | 80 | High School | Car | Urban |
The data looks like taking survey with different times for the same users.
I would like to ask some suggestions that what would be the best comparison idea to compare 1st time data and 2nd time data.
Thank you for your suggestion.
Solved! Go to Solution.
maybe you can create a column
rank = RANKX(FILTER('Table','Table'[User ID]=EARLIER('Table'[User ID])),'Table'[Date],,ASC)
Proud to be a Super User!
maybe you can create a column
rank = RANKX(FILTER('Table','Table'[User ID]=EARLIER('Table'[User ID])),'Table'[Date],,ASC)
Proud to be a Super User!
That's really help for me.