Forum Discussion

Clarisse's avatar
Clarisse
Regular Visitor
9 years ago

Add a column with an iterative formula

Hello :)

 

I would like to add a column to my table with "modification x" with x going from 1 to x+1 while the first column is not blank..

Is it possible in Power BI?

 

Thanks

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Not following this, can you post some example data and then what you want in your new column?

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Clarisse,

     

    Could you post your table structures with some sample data and the expected result against it, so that we can better assist on this issue? :smileyhappy:

     

    Regards

    • Clarisse's avatar
      Clarisse
      Regular Visitor
      9 years ago

      Hi v-ljerr-msftand Greg_Deckler,

       

      For example I got : 

      I would like to have a third column with, for each line, Modification1, Modification2, Modification3, Modification4...

      Those datas come from a SharePoint List and and they are going to change and to grow, I want to be sure that if there is a new line added there will be ModificationN+1 on the third column.

      I can't modified the SharePoint List and I don't want to use an excel sheets with the datas because I want to refresh it directly from Power BI.

       

      Thanks :) 

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi Clarisse,

         

        If I understand you correctly, you should be able to follow steps below to add this column in your table. :smileyhappy:

         

        1. Add an Index column in Query Editor under Add Column > Index Column > From 1.

         

         

        2. Then use the formula below to add a new calculate column in your table.

        Column = "Modification" & Table1[Index]

        Note: just replace "Table1" with your real table name.

         

         

        Regards