Add a column with an iterative formula

[Clarisse]

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]

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? 

Regards

[Clarisse]

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]

Hi @Clarisse,

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

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]

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

[Greg_Deckler]

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