Forum Discussion
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 ...
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 ) )
