Forum Discussion
Change Cell Values depending on their row number
Hello,
I have a Chart with about ten Columns of Number values. After i pvot that chart i obviously loose the Title of these numbers. I want to add a column that displays the title again. The title will always be in the same row number im hoping that there is a way to do this. For example row 33 should read "Title 1", row 34 should read "Title 2", row 35 should read "Title 3" and so on. Please see the attached photo.
Hi Zneta ,
1. You can create index column in power query editor to get the current number of rows.
2. Create calculated column.Column = IF('financials'[Index] >= 33, "Title" & 'financials'[Index] -32)If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Zneta ,
1. You can create index column in power query editor to get the current number of rows.
2. Create calculated column.Column = IF('financials'[Index] >= 33, "Title" & 'financials'[Index] -32)If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.