Forum Discussion

Thigs's avatar
Thigs
Icon for Helper IV rankHelper 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 ) )
Thigs's avatar
Thigs
Icon for Helper IV rankHelper IV
4 years ago

Hi! Ok, this looks helpful but I'm still confused. 

 

I created a summary table with the date and SKU of each. Now, for this formula, do I need to make a column so it iterates, or a measure?

 

To me, it seems like I'd do - 

Match Percent = CALCULATE(VALUES('SKU Distribution Table'[SKUs]),'SKU Distribution Table'[Date Only] = DATEADD('SKU Distribution Table'[Date Only] -1)

Or something like that to get the values of the date prior. 
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity 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)