Measure - same day last week per column

Hi, darylmc ,

you could write your measure like this:

LW Avail =
VAR _product =
    CALCULATE ( SELECTEDVALUE ( History[Product] ) )
VAR _date =
    CALCULATE ( MAX ( History[Date] ) )
VAR _store =
    CALCULATE ( SELECTEDVALUE ( History[Store] ) )
RETURN
    IF (
        HASONEVALUE ( History[Product] ),
        CALCULATE (
            DIVIDE ( SUM ( History[avail_sum] ), SUM ( History[avail_count] ), "" ),
            FILTER (
                ALL ( History ),
                History[Date] = _date - 7
                    && History[Store] = _store
                    && History[Product] = _product
            )
        ),
        CALCULATE (
            DIVIDE ( SUM ( History[avail_sum] ), SUM ( History[avail_count] ), "" ),
            FILTER ( ALL ( History ), History[Date] = _date - 7 && History[Store] = _store )
        )
    )

Cheers,
Sturla