Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Query
Answered

Custom Column

(0) ShareShare
ReportReport
Posted on by 2

Hello everyone!

 

I got stuck with a data set I'm working right now, and i will appreciate any help I can get. 

 

In my first column i have different ID numbers. The ID number appears first, and right bellow it all the transactions that were associated with that ID number, then the next ID number comes up, and again all the transactions associated with it. 

 

For a better analysis, I am trying to create a custom column that has the ID number right beside the transaction, but I am failing to do so, as can be seen in the attachment.

 

Is it possible to do that using Power Query? I will appreciate any help I can get. 

 

Thank you in advance for your comments.

  • Crisomac19 Profile Picture
    2 on at
    Re: Custom Column

    Thank you a lot, it was way easier than what I was trying! I really appreciate it

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Power Query

#1
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 7

#3
SD-13050734-0 Profile Picture

SD-13050734-0 6

Overall leaderboard

Featured topics