Forum Discussion
Ending Inventory using January value and carrying forward the answer as beginning inventory MOM
Anonymous you can take advantage of openingbalanceyear DAX function, read more about it here: OPENINGBALANCEYEAR function (DAX) - DAX | Microsoft Learn
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist
Super UserAnonymous you can take advantage of openingbalanceyear DAX function, read more about it here: OPENINGBALANCEYEAR function (DAX) - DAX | Microsoft Learn
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist
Thank you for your response. The first issue, is the ending inventory, I included what I should see, but that's something I need the formula for and the premise is that I need to take the beginning inventory, add the inbound, subtract the outbound to get the answer. I am currently watching a closing balance youtube option as the opening balance isn't working for me.