Forum Discussion
Copy/Duplicate Value
Hi good day,
Can anyone help me on how can I achieved my required value in column. On my table I want the value of AREA to be copied on Non Productive per trade and per week.
DESIRED OUTPUT
Thank you
pls see the attachment below
12 Replies
You'll need to go down into Power Query and Fill down - https://learn.microsoft.com/en-us/power-query/fill-values-column
Hi AllanBerces - You need to ensure that the AREA column is copied for "Non-productive" rows based on the respective Trade and Week ID.
Please find the attached pbix file. with solution.
Hope this helps.
Hi rajendraongole1 thank you for the reply, but i dont see any solution on the attached file.
Hi, rajendraongole1 thank you, possible to do it on calculated column instead of PQ thank you.
If you don't want to use fill down. I think you still need to create an index column in PQ. Could you pls provide more data? You only have West in the last column?
