Forum Discussion
Post ProdigyCopy/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
vicky_Super User
You'll need to go down into Power Query and Fill down - https://learn.microsoft.com/en-us/power-query/fill-values-column
- rajendraongole1
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.
AllanBercesHi rajendraongole1 thank you for the reply, but i dont see any solution on the attached file.
- AllanBerces
Hi, rajendraongole1 thank you, possible to do it on calculated column instead of PQ thank you.
- ryan_mayu
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?
