Forum Discussion
Create/append a index column
Hi! How to create/append a index(1,2,3,4,5...) column in existing table with dax without using any condition or filter formular. Thanks. Any help is appreciated!
Thank you so much for the answer. I looked at the links you provide to me , but UNION() claim to have the same number of columns in both joined table. In my case I have a table of 9 columns, I want to append another column with a series of number.Here is example of table to demontrate:
| Name | Location |
| Marry | A |
| Aida | A |
| John | B |
| Mgdalena | C |
| John | E |
Now I want to apend column called index at the end with series of numbers such as 1,2,3,4,5...
I know GENERATESERIES() can provide this series but then how I can add it to that table so that it become:
| Name | Location | index |
| Marry | A | 1 |
| Aida | A | 2 |
| John | B | 3 |
| Mgdalena | C | 4 |
| John | E | 5 |
Thanks
