Forum

Using Power Query, bring each table into the PQ editor. Then perform a Merge (inner Join) on the common fields.

Thanks for the feedback. This forum is here to help. Post back any time you are having issues.

=XLOOKUP(H7&I7,'Csg Data'!A5:A838&'Csg Data'!B5:B838,'Csg Data'!M5:M838,"Not Found",0,1)

Upload a sample file highlighting your issues. If you post this same question on other forums, be sure to identify those other locations.

Paul, Are you able to upload a sample file showing an example of your source data and a mocked up solution for us to work with. 8-10 records should...

If you have the data in separate workbooks, you can append them in Power Query and then create your graphics in Power BI.

Take a look at this video on using a cell as a parameter.  

right after you bring the file into PQ, highlight the date column and append to the column the year. Append a consistent value to all cells (Add Cus...

your attached file does not include the source file. Cannot follow what you have done. Please explain the two tables shown. More information is nee...

Cleaning can mean different ideas to different people. You have not provided a mocked up solution of your data. Perhaps only the first 8-10 records ...

You could create a sample file of fictitious information that would resemble your actual file. Usually it is only necessary to create a file structur...

Suggest you re-upload your file as an excel file. Cannot manipulate data in a PDF or picture. Please explain succinctly your objective that you woul...

In the attached, I used Power Query to Unpivot the email table. letSource = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],#"Unpivoted Other Colu...

Not sure what you are asking. It would be real helpful if you mocked up a solution showing what it is your expected results should look like.

=IF(Table3[@[Due Date]]="NA","",IF(Table3[@[Due Date]]<TODAY(),"Overdue",IF(Table3[@[Due Date]]>TODAY()+30,"Not Due","Due Soon")))