Forum Discussion
Problem Merge Query
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
4 Replies
is it possible to share the pbix file with the sample data?
or
can you share the struture for both of the tablesThx 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?
the Problem is solved. So this question is answered.
Greetings Simon
