Power query: result depends on whether there are duplicate rows in two columns

Hi all,

Could I please have your help with the below matter?
I am looking for a formula that I can use in Power Query Editor. Basically I'm looking for an IF AND statement for power query. I want it to check for duplicate rows in two columns and give me different outputs depending on the findings.
Basically the logic would be:
- If A2=A1 and B2<>B1, then the result should be "Repeat". Otherwise, it should be "New".
Hopefully it makes sense, please let me know should there be any other info I can provide.

Thank you,
Ella

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Power query" does not give insight to the question. I have updated it for you this time because you are a new member. --6StringJazzer

Hello Ella2021 and Welcome to Excel Forum.
I feel that the logic is more complicated.
It would seem that the logic is that if a voucher number is listed for the previous day then "Repeat" but if the voucher number isn't listed for the previous day then "New".
If that is the case then you might try:

Formula:

Please Login or Register  to view this content.

That said doing this in Power Query seems overly complicated, as indicated by the following linked article: https://exceloffthegrid.com/power-qu...itional-logic/
I would suggest using the formula above rather than attempting either the "Power Query If logic using a conditional column" or "IF logic by writing the M code" methodd from the article.
Let us know if you have any questions.