Forum Discussion
Find the text from string and remove remain part
I am not sure it will work with your big dataset, but you can try the following in Power Query:
1) Sort your table by "Document Number".
2) Add a conditional column.
3) Apply "Fill Down" form the newly created column.
Best Regards,
Alexander
Hi barritown ,
Thank you for your solution,
it really works, but I have 2.8 million rows in my table, and now almost 6-7 hours I am waiting for the result, it just stuck on "Working on it"...
Is there any other ways to realise it, maybe in Power query?
- barritown
Solution Sage
Hi Nurzh,
I knew my solution is greedy in terms of resources, but 6-7 hours - wow.
I will think how to opimize my [DAX] solution - not sure that I will be able to turn hours into minutes, but I'll try. Before that, could you please clarify how many "master" entries you have among those 2.8 million rows?
As for the Power Query solution, maybe it is worth duplicating this post in the "Power Query" section of this forum - I guess Power Query gurus live there. 🙂
Best Regards,
Alexander
Hi barritown ,
There is approximately 2.7 million of them "Master Documents".
Sure I will try to duplicate post in Power Query section, thank you, hope we can find the best solution 🙂
- barritown
I am not sure it will work with your big dataset, but you can try the following in Power Query:
1) Sort your table by "Document Number".
2) Add a conditional column.
3) Apply "Fill Down" form the newly created column.
Best Regards,
Alexander