Forum Discussion
Solved
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 ...
pls see the attachment below
you can try this
Column = maxx(FILTER('Table','Table'[Trade]=EARLIER('Table'[Trade])&&'Table'[weekid]=EARLIER('Table'[weekid]) &&'Table'[AREA]<>""),'Table'[AREA])
pls see the attachment below
Hi ryan_mayu rajendraongole1 vicky_ thank you very much working perfectly.