Forum Discussion
Inventory calculation using DAX
Hi All, I want to calculate the Closing/Opening inventory using DAX. What I have: Brand |Jan Inv a |400 b |750 c |400 Brand |Month |Sales a |Oct-20 |900 a |Nov-20 |500 a |Dec-20 |...
Hi Anonymous ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
Best Regards
Hi
"..According to the data in your table, the sales of Brand a in February is 1000, and the sales of Brand b is 500. Why are you here Brand a and b are 800 and 1000 respectively ? "
It's a copy paste mistake 😞
"..And is the OP Inv of the next month equal to the CI Inv of the previous month? "
Yes. I also think it requires a recursive calculation.
Kris
Hi Anonymous ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
Best Regards