I don't understand your question "because Yes is connected to the logical operator AND?"

My solution was to sort the Yes/No column (don't forget to use Table.Buffer) in descending order. This will always put a Yes before a No. Should you have two otherwise identical transactions, both with Yes or both with No, it doesn't matter. Only the first one is kept after deleting duplicates.

Hi Riny,

Wow - it worked adding Table.Buffer around the sorting step, now saying Yes output of legal contracts!

First I sorted some columns in second last step, and added Table.Buffer ( .... ) arround this sorting code, when looking at your previous Excel file..

Hehe, how is this possible!!

A small part of my producion file attached. I was going to add it in my last post, but you were just to quick answering.. 😉

I've also understood now, that adding attachments here should be done in Excel, not in .pbix format.

Sorry again asking some questions, I've just been in Power BI/Query like 3-4 months, but this has been a good learning process (my second project this too).

Trond

Glad to hear you enjoy learning PQ. 

Catalin:

I did it!! Hurra.. as we say it in my country, Norway.. -<

Just wanted to say I am happy for your contribution here as well.

I will look into your code in more depth later, as it could give me other methods to work in as well.

Last (actually my first) time on this forum I had a question, your help was also just priceless for me

So long guys & thanks again

Trond