In fact, I have a double query

I enclosed the file.  If I want to compare Data 1 with Data 1b then add a formula that will allow me to copy a data in a cell with a criteria

If Data 1=2 and Data 1b= 2 then data 2 = B and data 3 = B

I am not sure that would be the best formula for this

Hi Dieneba,

It's not clear what you're referring to as there is nothing in your file called Data 1 and Data 1b that I could see. However, you can use Power Query to compare lists.

If you still have questions after reviewing the Power Query tutorial, please come back with a small sample file (10 or so records) that illustrates the before and after results you'd like to see using anonymised email addresses.

Mynda

Hi Mynda

I looked at Power Query to compare the list link you sent me.  I managed to use it and merged the new data with the previous one ensuring there are no duplicates based on the date and email so that's ok. 

However, I have one more issue.  I still do not have the right formula to fill in the column based on specific criteria which would be:

In the example I enclosed

If in cell B2 the email is alice.kaki@***** AND C2,  BU=1983

THEN all cells in column B with alice.kaki@***** should have in column C BU-1983

I am not sure if this is feasible in Power Query or whether I should use Excel formulas but which one?  The issue is that reference is made to the email address, not the cell number. Does that mean I have to enter in the formula each email address?

Thanks for your help

Regards 

Hi Dieneba,

Thanks for the file. You can do this with Power Query. First, use a merge to lookup the BU in the original document and bring it into the May document. then append the two to make a final result. See attached.

Mynda

Hi Mynda

From the file if I understand well:

1- you merged the original and the new data based on BU only?

2-You combined original and new data using = Table.Combine({OriginalData, NewData})

Thanks a million for your help

Sorry but how do I get to know all this?  

I looked up today after your message (I would have never known this function existed).  I found this on Microsoft

Table.Combine - PowerQuery M | Microsoft Learn

 I do not always understand Microsoft explanations on their websites (I spent all day yesterday working on this :). 

I did your training which is really good but I lack some understanding (my  own lacking) so I need to read to compensate.  I found this book Livre Power Query et M - Extraire et préparer les données en vue de leur exploitation dans Excel ou Power BI (editions-eni.fr)

It's in French but it has a guide on M Code.  Does it seem ok for you or would you have a reference (for beginners and intermediate) to suggest (English or French does not matter).

Bye for now Mynda and thanks again, you are great

Regards

Dieneba

Hi Dieneba,

If you click on the cog icon in the Final Data Query Source step, you'll see I did this using the Append Queries tool (Home tab of the ribbon). No need to learn the function. It's all point and click. I covered this topic in lesson 3.04 of the Power Query course.

I think you just need to practice more. The more you practice, the more it will become automatic for you to know what tools to use to solve your needs.

Indeed, Microsoft's function explanations are lacking in detail and examples. It's difficult for me to evaluate that book as I don't speak French, but I'm sure any further learning you do will be worthwhile. 

Mynda

Thanks Mynda

You are right

Regards

Dieneba