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
I do have a date table already incorported. I'm currently reviewing Amit Chandak's youtube video Abstract Thesis 92 and seeing if I can use that for this solution as well.