cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Clarisse Frequent Visitor
Frequent Visitor

Add a column with an iterative formula

Hello Smiley Happy

 

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 5
Super User
Super User

Re: Add a column with an iterative formula

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


v-ljerr-msft Super Contributor
Super Contributor

Re: Add a column with an iterative formula

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? Smiley Happy

 

Regards

Clarisse Frequent Visitor
Frequent Visitor

Re: Add a column with an iterative formula

Hi @v-ljerr-msftand @Greg_Deckler,

 

For example I got : PBI_AddColumn.PNG

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

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 Smiley Happy 

v-ljerr-msft Super Contributor
Super Contributor

Re: Add a column with an iterative formula

Hi @Clarisse,

 

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

 

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

 

index1.PNG

 

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.

 

c2.PNG

 

Regards

Highlighted
Clarisse Frequent Visitor
Frequent Visitor

Re: Add a column with an iterative formula

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