Problem Merge Query

[Simon_Br]

Hello,

I want merge two query in Power Query. For that i have two same query. The query are sorted by UniqueNumer and Time and was grouped whit a Index. So far so good.

After merging, the index has shifted and no longer matches the sort order. Thus also wrong results are delivered.

UniqueNumber	Time	Step	Index	Index - 1	-->    Merge	My favorite Solution
12	10:02	A	1	0		B
12	10:14	B	2	1		C
12	10:26	C	3	2		D
12	10:38	D	4	3
18	18:04	A	1	0		B
18	18:23	B	2	1		C
18	18:42	C	3	2		D
18	19:01	D	4	3

Does anyone know this problem and can help me? Thanks in advance!

Simon

[Simon_Br]

the Problem is solved. So this question is answered.

Greetings Simon

[Simon_Br]

Thx for the respons. I have creat a new Power BI whit only two query from excel. This functionality whitout problems. But my Story basicly on a Azure Platform. Is this posibly a Problem?

[mussaenda]

Hi @Simon_Br ,

Just add a full table index before merging.

Then after merging, sort your table according to the full table index

[Ujjawal]

is it possible to share the pbix file with the sample data?
or
can you share the struture for both of the tables