Forum Discussion
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...
Hi,
You can try PIVOT in power query editor.
https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/power-bi-data-sources/pivot-column-in-power-query/
Thank you tried but its not working.
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 🙂