Previous Year September 30th Headcount

[BIBRO]

I want my measure headcount from September 30th to show the same for every date until September 30th comes again.

Date	Headcount
9/30/2020	5
10/1/2020	5
10/2/2020	5
10/14/2020	5
…
9/28/2021	5
9/29/2021	5
9/30/2021	12
10/1/2021	12
10/2/2021	12
10/3/2021	12
…
9/28/2022	12
9/29/2022	12
9/30/2022	20
10/1/2022	20
10/2/2022	20
10/3/2022	20

[some_bih]

Hi @BIBRO you can create measure Head count reset sep 30. Create Date / Calendar table and connect it with your table. Adjust Sheet2 to your table name.

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Head count reset sep 30 =

VAR _current_date = MAX('Date'[Date])

VAR _sep_30 = DATE(YEAR(_current_date), 9, 30)

RETURN

    IF(_current_date <= _sep_30 && _current_date >= DATE(YEAR(_current_date)-1, 10, 1),

        CALCULATE(SUM(Sheet2[Headcount]), 'Date'[Date] = _sep_30)

    )