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
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...