Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
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
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 🙂
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
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...
Not following this, can you post some example data and then what you want in your new column?
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |