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 ,

 

Is your issue solved now?

 

Best Regards,
Kelly

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

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

    v-kelly-msft 

     

    Thanks for your help, but I still could not make work. The results from the loops are not what I expected.. 
    I have too many variables that iterate ... the examples are usually very simple and I still can make the connection ...