Comparison Charts for the Same ID

[zawlh]

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.

[ryan_mayu · Accepted solution]

@zawlh 

maybe you can create a column

rank = RANKX(FILTER('Table','Table'[User ID]=EARLIER('Table'[User ID])),'Table'[Date],,ASC)

[zawlh]

That's really help for me.