Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculated Column in One table based on the other table in Power BI

I have below two tables with no existing relationships.

 

1) LoanTable 

Loan Type

Emp ID

Total Outstanding Amount

 

2) LoanReferenceTable

Loan Type

Interest %

 

Now I need to create a calcuated column in LoanTable which multiplies Total Outstanding Amount with Interest % matching the Loan Type.

 

Please help.

Need Help
Show and Tell
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi  Anonymous ,

     

    Create a column similarly as below:

    Column = 
var _lookupvalue=LOOKUPVALUE(LoanReferenceTable[Interest %],'LoanReferenceTable'[Loan Type],'LoanTable'[Loan Type],0)
Return
_lookupvalue*'LoanTable'[Total Outstanding Amount]

    And you will see:

     

    For the related .pbix file,pls see attahced.

     

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

     

2 Replies