Forum Discussion
Ending Inventory using January value and carrying forward the answer as beginning inventory MOM
I have a data set and I'm trying to get the following output in a BI visual. I have been doing a filter formula to get the beginning inventory for January, but that's where it goes south. Help would ...
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
parry2k
Super User
Super UserAnonymous sounds good - although the DAX function I gave will take care of it. Good luck!