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

[ragnargylfa]

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 me total cost for each job

Job Cost

A    6

B    6

C    1

I have a third table that contains estimated cost of jobs (not all though)

Job Est

A     8

C     7

How can I create the final table that would look like this?

Job Cost Est

A     6      8

B     6     

C     1      7

[v-jiascu-msft · Accepted solution]

@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]

Thanks!

This worked for me 🙂