Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
peterlongley77
New Member

Help with getting values from other rows in a table where id is the same

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

 

IDTransDateTypeValue
123410/01/2025BE £ 15,200.00
123413/01/2025OR £ 15,190.00
123425/01/2025OT £        10.00

 

And what I am looking to achieve is a table which shows the values like this. 

 

IDTransDateTypeValueTypeValueTypeValue
123410/01/2025BE £ 15,200.00OR £ 15,190.00OT £   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.

1 ACCEPTED SOLUTION
peterlongley77
New Member

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.

View solution in original post

5 REPLIES 5
v-csrikanth
Community Support
Community Support

Hi @peterlongley77 

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.

 

peterlongley77
New Member

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.

v-csrikanth
Community Support
Community Support

Hi @peterlongley77 

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.

v-csrikanth
Community Support
Community Support

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

nilendraFabric
Super User
Super User

Hello @peterlongley77 

Not sure if I understand this properly, But I have tried to get teh results from the sample data 


nilendraFabric_0-1738776331355.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.