Excel Expert Pivot Table

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

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

ID do Projeto: #6818159

4 freelancers estão ofertando em média $12/hora para esse trabalho


Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have bee Mais

$13 USD / hora
(4 Comentários)

A proposal has not yet been provided

$12 USD / hora
(0 Comentários)

i am expert in excel and power point.I can do this job easily.I hope you'll consider me for this job.I am waiting for your response.

$12 USD / hora
(0 Comentários)

Good day, My name is Nikola Nuspahic and I am business manager at BlueViSion IT Solutions. It is a team of web developing and market research experts from East Europe. Our expertise are Web Development, Database Dev Mais

$12 USD / hora
(0 Comentários)