Change Cell Values depending on their row number

[Zneta]

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.

[v-kaiyue-msft · Accepted solution]

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.