Associate measure to a date

Hello everyone,

I'm dealing with my first report. It should allow me to calculate and forecast inventories.

In this aim, I'm using formulas to calculate inventories at the end of the month (based of the inventory of today). Then I will be able to calculate inventories at the end of the current month +1, then at the end of the current month +2….

Example : inventories_end_march= inventories_today -  forecasts (sales)_march +  expected_goods_march

As you can see : Inventories, forecast, and expected goods have a link with a date (and so with my Dimension table DATUM) but I want inventories_at_the_end_of march to be related with end of 03/2022. Actually it is not the case because there are expected_goods all along the month. The better would be to group that (expected_goods) for the month (without changing links between my tables). Do you think that is possible and that I would have a date related to the measure that I created ?

Thank you in advance for your answer