Help with grouping data

[SureshbabuB]

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	Person1	SB	24/11/2022
206	Person1	SB	28/04/2022
206	Person1	SB	09/11/2021
207	Person2	AB	24/11/2022
207	Person2	AB	28/04/2022
208	Person3	XY	09/11/2022
208	Person3	XY	15/05/2022

Expected result

ID	Name	Initials	Appointment date1	Appointment date2	Appointment date3
206	Person1	SB	24/11/2022	28/04/2022	09/11/2021
207	Person2	AB	24/11/2022	28/04/2022
208	Person3	XY	09/11/2022	15/05/2022 0

Any suggestions to do this is in Power BI much appreciated.

Thanks,

Suresh

[Syk]

There's probably a decent way to do this but I'm curious why you're trying to. For reporting it's typically much easier to have all the dates in the same column, what are you trying to create?

[SureshbabuB]

Thank you, its a requirement to hide the repeating values and show the distinct dates in a single row. i.e one row per person.

I have done these in SQL and in other tools, its bit tricky here in Power BI. will keep trying.

[andhiii079845]

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/p...

[SureshbabuB]

Thank you tried but its not working.

[andhiii079845]

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 🙂