Forum Discussion
Custom Column
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.
Hi,
You can add a new custom column like this:
if Text.Contains([Entity], "-") then [Entity] else nullThen select your new column and go to the Transform tab > Fill (dropdown) > Down.
Then filter your [Entity] column on Does Not Contain "-".
Pete
3 Replies
Hi,
You can add a new custom column like this:
if Text.Contains([Entity], "-") then [Entity] else nullThen select your new column and go to the Transform tab > Fill (dropdown) > Down.
Then filter your [Entity] column on Does Not Contain "-".
Pete
Thank you a lot, it was way easier than what I was trying! I really appreciate it
No problem, happy to help.
Feel free to give a thumbs-up and accept the answer as the solution 👍
Pete
