Forum Discussion
Post ProdigyChange 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. below my table
DESIRED OUTPUT
Thank you
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.
7 Replies
- ajaybabuinturi
Super User
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.
AllanBercesHi 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.
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.
- 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.
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.
