Help --- Calculate the ending inventory

Hi naoyixue1 

I think you need cumulative the work order before current month. Your Work order column may be a Measure, however, I don't know its calculate logic.

You may try this measure:

Cumulative Work Order = calculate(Sum([Work Order]),Filter('Calendar','Calendar'[Date]<= Max('Calendar'[Date])))

If this reply still couldn't help you solve your problem, could you show me the calculate logic of your work order measure.

And I need to know your data model to understand your measure, you can show me a sample data model like the one you are dealing with. Or you can share your pbix file with me by your Onedrive for Business.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Hi naoyixue1 

Could you kindly accept the helpful reply as a solution? More people will benefit from it. 

Best Regards,

Rico Zhou