DAX function for initial stock

[annemiranda8]

Hello, I have a table where i have my initial stock for my current month, antoher table where i get my unit sales and another tabel where i get my purchases.



To calculate my final stock of the month i calculate initial stock - sales + purchases.



I only have my initial stock for the first month(current month), for the others months the inital stock must be the final stock of previous month.



For my sales and purchases i have data of all the year.

I need help with a function that takes lasts months final stock and uses it as the new initial stock.

 

[mamady]

Hi Dear,

Why can't simply link the cell to the final stock cell, and drag all the way to the right? (i.e. assuming June's final stock price is cell B6, the in July initial stock cell just type =B6, and drag that formula all the way to the right)

like the below screen shot

If my understanding of your requirement is not clear, please excuse my negligence and explain to me what you require.

Best Regards
M. Yusuf

 

[annemiranda8]

Hello!!

Thanks for you answer! That’s exactly how I have it right now on my excel, but my data is huge and so many different brands and that’s why I decided improve my excel on Power Bi. I’ve been trying to figure it out how to do this logic on Power Bi but I don’t know how.

Do you have any idea?

Thank you very much!

Anne

 

[mamady]

Hi Anne,

Thank you for the clarification, my bad I did not fully understand the question.

Unfortunately, I am not Power Bi expert myself, but I benefited a lot from the below tutorial:

Tutorial: Create your own measures in Power BI Desktop - Power BI

Measures in Power BI Desktop help you by performing calculations on your data as you interact with your reports.

docs.microsoft.com

.

Please try it out, and let me know if you are facing any issue, I might be able to help.

Thank you dear

Best Regards
M. Yusuf