Increase Order and Price

Hi, andreaturri27 

According to your description, you can create two measures.

Like this:

Measure1 = 
VAR a =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            [ExpectedDeliveryDate] < SELECTEDVALUE ( 'Table'[ExpectedDeliveryDate] )
        ),
        [ExpectedDeliveryDate]
    )
VAR b =
    MAXX (
        FILTER ( ALL ( 'Table' ), [ExpectedDeliveryDate] = a ),
        [Prezzo acquisto]
    )
RETURN
    MAX( 'Table'[Prezzo acquisto] ) - b

Measure2 = 
VAR a =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            [ExpectedDeliveryDate] < SELECTEDVALUE ( 'Table'[ExpectedDeliveryDate] )
        ),
        [ExpectedDeliveryDate]
    )
VAR b =
    MAXX (
        FILTER ( ALL ( 'Table' ), [ExpectedDeliveryDate] = a ),
        [Prezzo acquisto]
    )
RETURN
    DIVIDE (
        MAX ( 'Table'[Prezzo acquisto] ) - b,
        MAX ( 'Table'[Prezzo acquisto] )
    )

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,

Community Support Team _ Janey

Hi, andreaturri27 

You need to modify the code according to your needs.

Like :

Measure1 = 
VAR a =
    MAXX (
        FILTER (
            ALL ( 'Table' ),
            [ExpectedDeliveryDate] < SELECTEDVALUE ( 'Table'[ExpectedDeliveryDate] )&&
            [item] < SELECTEDVALUE ( 'Table'[item] )
        ),
        [ExpectedDeliveryDate]
    )
VAR b =
    MAXX (
        FILTER ( ALL ( 'Table' ), [ExpectedDeliveryDate] = a && 
        [item] < SELECTEDVALUE ( 'Table'[item] )),
        [Prezzo acquisto]
    )
RETURN
    MAX( 'Table'[Prezzo acquisto] ) - b

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.

Best Regards,

Community Support Team _ Janey