Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
79 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |