Forum Discussion

MCstudio's avatar
MCstudio
Helper I
4 years ago

Merge by condition and approximate matching in Power Query

Hi community! I have got a question. We have got clients, who do orders, and managers, who control orders. The final goal is to understand, which manager provide what volume of orders. But, during ...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

"Too long - yes, I mean the number of steps."

So your problem is not the execution time, but the code size !?
In this case, wdx223_Daniel's solution (which could also be reduced by eliminating a redundant instruction and, if your db is sorted, eliminate two steps) seems to me to be right for you.

MCstudio's avatar
MCstudio
Helper I
4 years ago

Dear Anonymous ,

the wdx223_Daniel 's solution seems to be the best, but how I answered to the wdx223_Daniel 's message, there is a minor problem, which time to time results in an error.

Yesterday, at home I tried the code, it worked. Today at the office, it didn't. I was trying to find out, what is the reason. The only difference I have found, is date format.

Data format:

Home PC - dd.mm.yyyy

Office PC - dd/mm/yy

 

I guess, at office, this code change days' and months' places and results in an error.

 

If you, or wdx223_Daniel help me, to correct the code, which will work with both formats, I will be grateful.