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 calc...
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!

     

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
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!