Forum Discussion
Anonymous
3 years agoNot applicable
Help with grouping data
Hello team, I'm relatively new to Power BI and need some help please. I have a requirement to display the following data in a summarised view ID Name Initials Appointment date 206 Person...
Anonymous
3 years agoNot applicable
Thank you tried but its not working.
andhiii079845
3 years agoSolution Sage
You need a rank of the date within a PersonID like this
| Person | Date | Rank |
| 1 | 2023-01-01 | 1 |
| 1 | 2022-12-01 | 2 |
| 2 | 2023-01-01 | 1 |
| 2 | 2022-12-01 | 2 |
Nevertheless, why do you want to do this kind of transformation 🙂