Create a measure to calculate a value difference between the latest and the earliest date

Hello Anonymous,

You can use the following DAX formula:

TotalAmount =
CALCULATE(
    SUMX(
        TableName,
        TableName[qty] * TableName[price]
    ),
    FILTER(
        TableName,
        TableName[date] = MAX(TableName[date])
            || TableName[date] = MIN(TableName[date])
    )
)

Should you require further details or assistance please do not hesitate to reach out to me.