Forum Discussion

felipecarvalho's avatar
felipecarvalho
Icon for Helper I rankHelper I
5 years ago

Stock Portfolio Control ! Can i use the column that I am creating on the same calculation?

I Want do to a calculation that can track the Median Acquisition  (better explaining in the next reply) cost of my stocks.   This number should be only affected by my Buys!     When I sell the St...
Need Help
Tutorial Requests
felipecarvalho's avatar
felipecarvalho
Icon for Helper I rankHelper I
5 years ago

v-kelly-msft   

First of all thanks for your reply!

 

I am not trying to solve this I'm powerBI , but in PowerQuery.

In order to automate the entire process I need to solve this with M code.

I am finding it very difficult but I think there is a way. 

One hint was this post about recursive functionalities:

https://community.powerbi.com/t5/Community-Blog/Fun-with-Graphing-in-Power-BI-Part-SQRT-POWER-SQRT-8-2-POWER/ba-p/385953

but so far I am still in a dead-end...

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi felipecarvalho ,

 

Sorry I didnt notice it.

I found a vedio teaching how to do loop in power query which may help:

https://www.youtube.com/watch?v=mXbjoSg9ldo

Let me know if you are still frustrated.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!