Forum Discussion
zawlh
Helper I
4 years agoComparison Charts for the Same ID
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.
maybe you can create a column
rank = RANKX(FILTER('Table','Table'[User ID]=EARLIER('Table'[User ID])),'Table'[Date],,ASC)