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 moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
86 | |
85 | |
67 | |
49 |
User | Count |
---|---|
134 | |
113 | |
100 | |
68 | |
67 |