Compare value between two dates

Hi gjloureiro

Try these MEASURES

Actual Price =
CALCULATE (
    VALUES ( TableName[PRICE] ),
    FILTER (
        ALLEXCEPT ( TableName, TableName[CLIENT] ),
        TableName[DATE] = MAX ( TableName[DATE] )
    )
)

Date of Actual Price =
CALCULATE (
    LASTDATE ( TableName[DATE] ),
    ALLEXCEPT ( TableName, TableName[CLIENT] )
)

gjloureiro

Following MEASURES for the previous/last DATE and VALUE

lastdate =
VAR last_price = [Actual Price]
RETURN
    CALCULATE (
        MAX ( TableName[DATE] ),
        FILTER (
            ALLEXCEPT ( TableName, TableName[CLIENT] ),
            TableName[Actual Price] <> last_price
        )
    )

lastvalue =
VAR priordate = [LastDate]
RETURN
    CALCULATE (
        VALUES ( TableName[PRICE] ),
        FILTER (
            ALLEXCEPT ( TableName, TableName[CLIENT] ),
            TableName[DATE] = priordate
        )
    )

Hi gjloureiro,

You can try to use below table formula to get the analysed table.

Original table:

Formula:

Table = 
ADDCOLUMNS (
    SUMMARIZE (
        'Sample',
        [CLIENT],
        [ITEM],
        "Min", MIN ( 'Sample'[PRICE] ),
        "Max", MAX ( 'Sample'[PRICE] )
    ),
    "Last Min Price Date", MAXX (
        FILTER (
            'Sample',
            [CLIENT] = EARLIER ( [CLIENT] )
                && [ITEM] = EARLIER ( [ITEM] )
                && [PRICE] = EARLIER ( [Min] )
        ),
        [DATE]
    ),
    "Last Max Price Date", MAXX (
        FILTER (
            'Sample',
            [CLIENT] = EARLIER ( [CLIENT] )
                && [ITEM] = EARLIER ( [ITEM] )
                && [PRICE] = EARLIER ( [Max] )
        ),
        [DATE]
    )
)

Regards,

Xiaoxin Sheng