Display when the difference between two dates reaches a threshold for lines having a common value

Many thanks, for your precious help v-henryk-mstf . It is greatly appreciated 🙏

I shared below, a small sample of the data. I added on the sample, the expected result.

I could create a new column “Result”. It runs, no syntax error detected, but the result is quite different from expected :

• I have lines that are “YES”, however there is only one line for the company so there can’t be a comparison. For instance “2° Investing Initiative”.
• The few expected “YES” are not identified. For instance “2Empower”.
• On the contrary, there are companies identified “YES” while they shouldn’t. For instance “73 Strings”.

Here is your script, adapted to my real database labels :

Result =

VAR after_ =

    CALCULATE (

        SUM ( 'Table'[employees_count]),

        FILTER (

            ALL ( 'Table' ),

            'Table'[company_name] = EARLIER ( 'Table'[company_name] )

                && 'Table'[updated_at] > DATE ( 2022, 10, 01 )

        )

    )

VAR before_ =

    CALCULATE (

        SUM ( 'Table'[employees_count]),

        FILTER (

            ALL ( 'Table' ),

            'Table'[company_name] = EARLIER ( 'Table'[company_name] )

                && 'Table'[updated_at] < DATE ( 2022, 05, 30 )

        )

    )

RETURN

    IF ( after_ / before_ > 10, "YES", "No" )

Do you see where the error could originate ?

I noticed that the result doesn't change when the threshold in line 21 change.

Many thanks for your help,

------------------------------------------------------------------------------------------------------------------

Sample :

Result: