Forum Discussion
Recursive running totals
Recursions are very seldom really necessary. Oftentimes you can use simple list operations to achieve the same goal.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi and thanks for this; the case is a bit complicated, but I make an attempt.
I am collecting fund transactions from various sites and trying to consolidate these. For some sites the challenge is to translate funds with foreign currency into my domestic one.
The key issue appears when shares are sold and to calculate the change to the domestic total acquisition cost for a specific fund.
In the example below the sales amount (Amt YYY) and the result (Res YYY) translates correctly into the acquisition value in the foreign currency. Just calculating the acquisition value impact using the the exchange rate for the sales date will give a skewed figure as the domestic acquisition value is aggregated over time with different exchange rates (see pink cells).
What I have tried to do is to calculate the domestic acquisition value per share for each date (AV/Share ZZZ) and then use that to calculate the domestic acquisition value (AV ZZZ) by using the AV/Share and transaction quantity and then calculating the total acquisition value (Tot AV ZZZ).
See attached link for the data. Calculating domestic AV
As mentioned a bit complicated, but hopefully possible to grasp.
Where's the recursive part in your process?