Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
the Problem is solved. So this question is answered.
Greetings Simon
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?
Hi @Simon_Br ,
Just add a full table index before merging.
Then after merging, sort your table according to the full table index
is it possible to share the pbix file with the sample data?
or
can you share the struture for both of the tables