Forum Discussion

ragnargylfa's avatar
ragnargylfa
Frequent Visitor
9 years ago
Solved

Joining two tables (left outer join), one is from source other is created with summarize.

Good day,   I have a table from a source which lists a cost for projects. i.e. Job  Cost A     1 A     3 B     6 C     1 A      2   I have created a new table using summarize which gives m...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    ragnargylfa

     

    Hi

     

    In your scenario, the column “job” in the table “estimated cost” should be unique. Please try this formula.

    FinalTable =
ADDCOLUMNS (
    SUMMARIZE (
        'CostOfProjects',
        'CostOfProjects'[Job],
        "CostofProjects", SUM ( 'CostOfProjects'[Cost] )
    ),
    "Est", LOOKUPVALUE ( 'EstimatedCost'[Est], EstimatedCost[Job], 'CostOfProjects'[Job] )
)

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

     

     

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

ragnargylfa

 

Hi

 

In your scenario, the column “job” in the table “estimated cost” should be unique. Please try this formula.

FinalTable =
ADDCOLUMNS (
    SUMMARIZE (
        'CostOfProjects',
        'CostOfProjects'[Job],
        "CostofProjects", SUM ( 'CostOfProjects'[Cost] )
    ),
    "Est", LOOKUPVALUE ( 'EstimatedCost'[Est], EstimatedCost[Job], 'CostOfProjects'[Job] )
)

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

 

 

  • ragnargylfa's avatar
    ragnargylfa
    Frequent Visitor
    9 years ago

    Thanks!

     

    This worked for me :)