Forum Discussion
Inventory calculation using DAX
Hi Anonymous ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
Best Regards
Super UserAnonymous , - was -1.
But I am not very clear on the structure of the inventory table. Can you confirm you have only first inventory or you have month on column
Hi Amit,
Inventory table has brand name and it's inventory value, nothing else.
HTH
Kris
Hi Anonymous ,
I have a question about the sales value of February in the expected results you listed. 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 ? And is the OP Inv of the next month equal to the CI Inv of the previous month? There is also a recursive calculation involved, which may not be easily implemented using DAX...
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