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