Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
minglis
Frequent Visitor

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

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 RegionActual
      Amount
      GL DateCorporate To RegionDivision From RegionTo CountryDiv SegExchange RateUS$Customer
      NAM - North America-1,050.001/17/2023NAM - North AmericaNAM - North America                 CA - CANADA                        Liner Hangers     1.3554          (774.68)CANADIAN NATURAL RESOURCES LTD
      NAM - North America-87.501/17/2023NAM - North AmericaNAM - 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 OthersD_NAM_NORTHCanada LandDrilling & EvaluationManaged Pressure DrillingTotal MPD Capital Sales                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationManaged Pressure DrillingTotal MPD Downhole Deployment Valve                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationManaged Pressure DrillingTotal MPD Compression                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationManaged Pressure DrillingTotal MPD Engineering                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationManaged Pressure DrillingTotal MPD Manifold Systems                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationManaged Pressure DrillingTotal MPD Rotating Control Device            428,623           407,532            567,746           498,284
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationManaged Pressure DrillingTotal MPD Software                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationManaged Pressure DrillingTotal Surface Testing Services                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationManaged Pressure DrillingMPD ISP                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationManaged Pressure DrillingTesting ISP                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationManaged Pressure DrillingSeparation System                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationDrilling FluidsTotal Drilling Fluids                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationDrilling FluidsTotal Drilling Waste Management                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationDrilling FluidsTotal Engineered Chemistry                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationDrilling FluidsDrilling Fluids ISP                        -                         -                          -                         -  
      Total OthersD_NAM_NORTHCanada LandDrilling & EvaluationDrilling ServicesTotal 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.

 

minglis_0-1675718562529.png

 

 

Thanks

Mike 

 

 

0 REPLIES 0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.