Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Add new calculated column with values from 2 tables (Power Query)

Hello all,    I'm really new to Power BI and Power Query and I am now struggling with the following:   Imagine we have Table1 and Table2, which can link by the column "Name":   Table1 Nam...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Anonymous ,

     

    Try adding this as a new custom column in Table2:

     

    let
  currentName = [Name],
  meters = Table.SelectRows(Table1, each [Name] = currentName){0}[Produced Meters]
in
  meters / [Run Time]

     

     

    This gives me the following output:

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Anonymous ,

 

Try adding this as a new custom column in Table2:

 

let
  currentName = [Name],
  meters = Table.SelectRows(Table1, each [Name] = currentName){0}[Produced Meters]
in
  meters / [Run Time]

 

 

This gives me the following output:

 

Pete

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you for showing me how it's done.