Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Not sure if anyone can assist with this I am sure it is possible but my head is ready to explode in trying to find the answer.
I am trying to get the data from other rows where the id is the same
So the data in the table will be for example this
ID | TransDate | Type | Value |
1234 | 10/01/2025 | BE | £ 15,200.00 |
1234 | 13/01/2025 | OR | £ 15,190.00 |
1234 | 25/01/2025 | OT | £ 10.00 |
And what I am looking to achieve is a table which shows the values like this.
ID | TransDate | Type | Value | Type | Value | Type | Value |
1234 | 10/01/2025 | BE | £ 15,200.00 | OR | £ 15,190.00 | OT | £ 10.00 |
There are multiple IDs within the table so it would go on and on but with only one row per ID.
Thanks in advance.
Solved! Go to Solution.
Sorry I ended up doing it a different way in the end, this was more complicated than the way I found to do it. It was pivoting the data and merging data from a copy of the data.
I sincerely apologize for any inconvenience caused.
If you have found an alternative solution to resolve your issue, kindly share your approach in the forum. This will be helpful for others facing a similar challenge.
If the provided solution worked for you, please consider marking it as accepted.
Best Regards,
Community Support Team _ C Srikanth.
Sorry I ended up doing it a different way in the end, this was more complicated than the way I found to do it. It was pivoting the data and merging data from a copy of the data.
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.
Hi @peterlongley77
As highlighted by @nilendraFabric , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.
Thanks and regards,
Cher Srikanth
Hello @peterlongley77
Not sure if I understand this properly, But I have tried to get teh results from the sample data