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