Forum Discussion

Helper IV

4 years ago

Solved

SKU Distribution Trend?

Hi all! I'm working with a client with about 4,000 SKUs in a given year. However, it is a very seasonal business, so only about 1,500 SKUs are in store at any given time. What I need to know is how ...

tamerj1

4 years ago

Thigs

This is only part of the complete measure

Matching Percent =
VAR CurrentSKUs =
    VALUES ( 'SKU Distributions'[SKU] )
VAR PreviousSKUs =
    CALCULATETABLE (
        VALUES ( 'SKU Distributions'[SKU] ),
        'SKU Distributions'[Date Only]
            = MAX ( 'SKU Distributions'[Date Only] ) - 1
    )
RETURN
    COUNTROWS ( INTERSECT ( PreviousSKUs, CurrentSKUs ) )

tamerj1

Community Champion

4 years ago

Thigs

I hope by summary table you mean table visual. Then you can create a measure. To retrieve the table of previous SKU's you need to use CALCULATETABLE.

DATEADD might not work being time intelligence function therefore you can use

CALCULATETABLE(VALUES('SKU Distribution Table'[SKUs]),'SKU Distribution Table'[Date Only] = MAX('SKU Distribution Table'[Date Only]) -1)