Create/append a index column

[Muzda]

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!

[Muzda]

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

[Fowmy]

@Muzda 

You can an Index column in Power Query

[Fowmy]

@Muzda 

The question is not clear, please have a look at the UNION function: 
https://docs.microsoft.com/en-us/dax/union-function-dax
https://www.youtube.com/watch?v=P-Pov3Fz_Ig