topic Re: Create/append a index column in Custom Visuals Development Discussion

Create/append a index column

Muzda — Sun, 03 Oct 2021 13:49:55 GMT

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!

Re: Create/append a index column

Fowmy — Sun, 03 Oct 2021 14:19:51 GMT

@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

Re: Create/append a index column

Muzda — Sun, 03 Oct 2021 16:34:05 GMT

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

Re: Create/append a index column

Fowmy — Sun, 03 Oct 2021 18:39:37 GMT

@Muzda

You can an Index column in Power Query