Forum Discussion

zawlh's avatar
zawlh
Icon for Helper I rankHelper I
4 years ago
Solved

Comparison 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 IDDateScoreEducationRideLocation
11/1/202050High SchoolBicycleUrban
11/1/202270Under GraduateBicycleRural

2

1/1/202040High SchoolBikeRural
21/1/202280High SchoolCarUrban

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.

  • zawlh 

    maybe you can create a column

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

     

2 Replies

  • zawlh 

    maybe you can create a column

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

     

    • zawlh's avatar
      zawlh
      Icon for Helper I rankHelper I

      That's really help for me.