How calculate a quarterly inventory turing days with a irregular order period?

[Mrgoodman]

Dear Experts,

I would like to get the COGS of current period, for example there are four consecutive periods as a fiscal year.

The last quarter period begin with 07/02/2022,later 10/1/2022,and then 12/31/2022.

Because a cumulative figures of COGS for fiscal year, I create a measure named COGS diff (COGS current period minus COGS Previous period),  it's fine for period which is not near the last fiscal year.

However, the beginnig of fiscal year (for example 07/02/2022), COGS diff should be equal to "489,200,000", not the difference between "489,200,000" and "2,071,000,000" from previous fiscal year.

How can i modificate the measure to consider this timing difference?And Get a result "489,000,000" for date 07/02/2022?

Thank you in advance.

[Mrgoodman]

could someone help?😣