Combine and compare two tables of related data, with no actual related columns.

[minglis]

I feel like I am going in circles.

I have two sets of data that I am trying to actively compare.

• one is an export from billing department software, two excel sheets combined and cleaned via power query.

  • Corporate From Region	Actual Amount	GL Date	Corporate To Region	Division From Region	To Country	Div Seg	Exchange Rate	US$	Customer
    NAM - North America	-1,050.00	1/17/2023	NAM - North America	NAM - North America	CA - CANADA	Liner Hangers	1.3554	(774.68)	CANADIAN NATURAL RESOURCES LTD
    NAM - North America	-87.50	1/17/2023	NAM - North America	NAM - North America	CA - CANADA	Liner Hangers	1.3554	(64.56)	CANADIAN NATURAL RESOURCES LTD

• one is a forecast by customer/area / PL / Quarter.
  • Customer NameGZCountry/AreaProduct FamilyProduct GroupProduct LineQ1'23Q2'23Q3'23Q4'23

    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Managed Pressure Drilling	Total MPD Capital Sales	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Managed Pressure Drilling	Total MPD Downhole Deployment Valve	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Managed Pressure Drilling	Total MPD Compression	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Managed Pressure Drilling	Total MPD Engineering	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Managed Pressure Drilling	Total MPD Manifold Systems	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Managed Pressure Drilling	Total MPD Rotating Control Device	428,623	407,532	567,746	498,284
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Managed Pressure Drilling	Total MPD Software	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Managed Pressure Drilling	Total Surface Testing Services	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Managed Pressure Drilling	MPD ISP	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Managed Pressure Drilling	Testing ISP	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Managed Pressure Drilling	Separation System	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Drilling Fluids	Total Drilling Fluids	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Drilling Fluids	Total Drilling Waste Management	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Drilling Fluids	Total Engineered Chemistry	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Drilling Fluids	Drilling Fluids ISP	-	-	-	-
    Total Others	D_NAM_NORTH	Canada Land	Drilling & Evaluation	Drilling Services	Total Directional Drilling	371,814	313,876	463,530	457,234

Where I am struggling is to compare the actuals with the forecast.  The two reports have no columns to reference each other.  Naming conventions are not the same between each report.  I tried creating a bridge table to link them together, but can't get away from a many to many relationship and it is not giving the results I am expecting.

Thanks

Mike