Forum Discussion

Thigs's avatar
Thigs
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's avatar
    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's avatar
tamerj1
Community Champion
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 ) )
Thigs's avatar
Thigs
Helper IV
4 years ago

Ok, so if I'm reading this correctly, this gives me the number of SKUs that are the same as the previous day. Then I need a percent, so I would divide by PreviousSKUs? Or do I need a new variable?