Forum Discussion

Zneta's avatar
Zneta
Frequent Visitor
2 years ago
Solved

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 titl...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.