Forum Discussion
Create a scrolled column down
I would like to create a new column called Contracts2 that is equal to the Contracts column but with the first value blank and the following with the value of the Contracts column but moved 1 row down.
I have found the solution. I have created an index column starting from the value 0, then in the steps applied I have renamed it and put "Row", the next step has been to create a custom column with the following code: try
Row[Framework Agreement]{[Index]-1}
otherwise [Framework Agreement]
3 Replies
Hello Syndicate_Admin ,
check if this solution works https://community.powerbi.com/t5/Desktop/New-column-to-populate-previous-value/m-p/223379
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
It is not exactly what I need, if in that code I remove the filtering part, what the new column returns contains the same values as the initial column, but I need to move all the values one row down and leave the first value blank
I have found the solution. I have created an index column starting from the value 0, then in the steps applied I have renamed it and put "Row", the next step has been to create a custom column with the following code: try
Row[Framework Agreement]{[Index]-1}
otherwise [Framework Agreement]
