Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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
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?
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.
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...
Proud to be a Super User!
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 🙂
Proud to be a Super User!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
User | Count |
---|---|
92 | |
92 | |
83 | |
80 | |
49 |
User | Count |
---|---|
146 | |
137 | |
109 | |
68 | |
55 |