Excel Expert Pivot Table -- 2

I need a DAX calculated column of the data model behind the attached Excel file that will reproduce the calculation of the yellow column of the spreadsheet data. If you open the data model with Power Pivot there will be a calculated column with 1's, and that is where the data should appear. You can use intermediate measures and columns to get to the result. Please post pictures of the data model measures and calculated columns, the contest is sealed so no-one else will see your entry. No macros please.

This result is needed to calculate the interest that becomes payable when the principal of a loan is partially repaid, where:

Payable interest = (Total interest accrued to date - Any amount already payable) x Repaid amount / Outstanding amount before repayment

The problem arises when there are a series of repayments, and you need to keep track of the amount already payable. I am using Power Pivot DAX and I get a circular reference error when trying to subtract the sum of the amounts already payable.

You will need Excel 2013 and PowerPivot add-in as well as Power View probably

Habilidades: Excel

Veja mais: open-table, macros expert, intermediate excel, file excel expert, excel model expert, excel expert 2013, repayment, power pivot, pivot table excel, need a excel expert, excel PIVOT, excel pivot table, excel expert, excel dax, excel calculation, excel add-in, excel add in, excel 2013, dax, contest data entry, excel 2013 expert, entry data loan, loan repayment model excel, expert powerpivot, excel spreadsheet loan repayment

Acerca do Empregador:
( 79 comentários ) Dhaka, Bangladesh

ID do Projeto: #6822331

4 freelancers are bidding on average $11/hour for this job


Ca do this quite easily.....please reply..............................................................................................

$8 USD / hora
(18 Comentários)

Hi Can u send me the excel file so that i can have a look into it and try to work on it. I am good at excel I can put a try into your work.

$10 USD / hora
(2 Comentários)

Hi, I'm Mahbub (Data Entry Expert) - ready to start your project at once. I will provide you 100% success work. ''When I start any work then I never think that it is my client's work, rather I always think it is my ow Mais

$12 USD / hora
(0 Comentários)

I have gone through you project and understand the nature of the project. Since I have been working on similar projects I wish to complete it for you in no time. I shall complete it within the schedule time. Thank You.

$12 USD / hora
(0 Comentários)