Change value on a certain column

[AllanBerces]

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. below my table

DESIRED OUTPUT

Thank you

[v-pagayam-msft]

Hi @AllanBerces ,
We are glad that the suggested solution helpedfor you.Please accept the helpful reply as a solution.It will be helpful for others who are facing similar issue.
Thank you.

[danextian]

Hi @AllanBerces 

You can write a conditional column either in DAX or M but you didnt tell us which rows need to be changed and why.

[ajaybabuinturi]

Hi @AllanBerces,
Wanted to know on what basis you want to change the output value?. If you provide that information that will be very helpful to us.

Based on your output data, I am asuming you want to change the negative(-) values to ZERO.
Caculated Column:

OUTPUT = IF('Table'[Total Progress] < 0, 'Table'[Total Progress], BLANK())

In PQ:
Click Add Column >> Custom Column >> rename it as OUTPUT >> use this formula >> if [Total Progress] < 0 then [Total Progress] else null >> click OK.

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

[AllanBerces]

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. 

[v-pagayam-msft]

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 · Accepted solution]

Hi @danextian @ajaybabuinturi @v-pagayam-msft 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.

[v-pagayam-msft]

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.