Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
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 ...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
1 year ago

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's avatar
    AllanBerces
    Post Prodigy
    1 year ago

    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's avatar
      ryan_mayu
      Super User
      1 year ago

      you can try this

       

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