Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Change value on a certain column

Hi and good day, Can anyone pls need help on my table, I want to try it on PQ and Calculated column. Basically I want to change the value of Total Progress on a certain Scope, Week No. and Year. bel...
Need Help
  • AllanBerces's avatar
    AllanBerces
    1 year ago

    Hi danextian ajaybabuinturi Anonymous thank you very much for the reply, it give some idea to resolve my concern. by adding new table from other source and solve my concern.

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
1 year ago

Hi ajaybabuinturi  danextian thank you very much for the reply, basically need to change the value on column Total Progress per Week and not only if negative to change the value coz there are time even Negative when sum up all the Total Progress per Week is equal to Total_Progress, like the example of scope 222rrf. Thank why if possible to change only the value on the certain Scope, Week No. and Year. 

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi AllanBerces ,
Thank you danextian and ajaybabuinturi for the helpful responses!

I tried to recreate in on my local with the sample data.Create a calculated column using below:

OUTPUT =
SWITCH(TRUE(),
    'Table'[Scope] = "VBGFR" && 'Table'[Week No.] = 24 && 'Table'[Year] = 2025, 'Table'[Total Progress],
    'Table'[Scope] = "HYJKU" && 'Table'[Week No.] = 42 && 'Table'[Year] = 2025, 'Table'[Total Progress],
    'Table'[Scope] = "JHYTR" && 'Table'[Week No.] = 2 && 'Table'[Year] = 2025, 'Table'[Total Progress],
    'Table'[Scope] = "NBGHT" && 'Table'[Week No.] = 17 && 'Table'[Year] = 2023, 'Table'[Total Progress],
    BLANK()
)



Please refer the below screenshot and attachment for your reference.


I hope this helps.
Thank you.

Regards,
Pallavi G.

  • AllanBerces's avatar
    AllanBerces
    Icon for Post Prodigy rankPost Prodigy
    1 year ago

    Hi danextian ajaybabuinturi Anonymous thank you very much for the reply, it give some idea to resolve my concern. by adding new table from other source and solve my concern.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi AllanBerces ,

      I'm glad to hear that your query was resolved! If our responses addressed your query, marking it as Accept Answer so that it allows us to ensure that the solutions shared are valuable for the entire community.
      Thank you.