Copy/Duplicate Value

[AllanBerces]

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

[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.

[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?

[AllanBerces]

Hi @vicky_ @ryan_mayu @rajendraongole1 please refer below link

https://docs.google.com/spreadsheets/d/1Edj0I6h4LnBf9QQ-1zrHADwot-BBSI31/edit?usp=sharing&ouid=10850...

[ryan_mayu]

@AllanBerces 

if you want to create a calculated column, you can try this

Column = maxx(FILTER('Table','Table'[Trade]=EARLIER('Table'[Trade])&&'Table'[AREA]<>""),'Table'[AREA])

pls see the attachment below

[AllanBerces]

Hi @ryan_mayu thank you very much for the reply, but show some in correct value in other week. possible to add filter by Week ID or WeekNo. Thank you

[ryan_mayu]

you can try this

Column = maxx(FILTER('Table','Table'[Trade]=EARLIER('Table'[Trade])&&'Table'[weekid]=EARLIER('Table'[weekid])  &&'Table'[AREA]<>""),'Table'[AREA])

[AllanBerces]

Hi @ryan_mayu show error 

Thank you

[ryan_mayu · Accepted solution]

@AllanBerces 

pls see the attachment below

[AllanBerces]

Hi @ryan_mayu @rajendraongole1 @vicky_ thank you very much working perfectly.

[AllanBerces]

Hi @rajendraongole1 thank you for the reply, but i dont see any solution on the attached file.

[vicky_]

You'll need to go down into Power Query and Fill down - https://learn.microsoft.com/en-us/power-query/fill-values-column