Measure to get the correct amount value respective to dates

[Ramees_123]

I have below three tables with no existing relationships.

1) LoanTable 

Loan Date 

Loan Type

Emp ID

Total Outstanding Amount

2) LoanReferenceTable

Loan Type

Interest %

3) Date table with date which is used as Year and Month slicers in reprot.

Now I need to create a measure which actually multiplies every month end date Total Outstanding Amount with Interest % matching the Loan Type. Also that measure should change based on the year and month slicer given in the report.

(Note: Date table also does not have any relationships)

Please help.

[amitchandak · Accepted solution]

@Ramees_123 , Join date of date table with loan date. Also join loan type

and try a measure like

sumx(values('Date'[Month Year]),calculate(CLOSINGBALANCEMONTH(sum(LoanTable [Total Outstanding Amount]), 'Date'[Date]), max(LoanReferenceTable[Interest %])))