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
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft 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
      Microsoft 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

      • Clarisse's avatar
        Clarisse
        Regular Visitor
        9 years ago

        You understood correctly,

        It doesn't work, it says that the access is denied.  I guess the SharePoint is too proctected and I am not the admin of it...