Goal: Extract specific parts of the SKU code.
Format: PREFIX-CODE-COUNTRY (e.g., ABC-1234-US)
Ready...
💻 DAX Formula
-- Scenario 1: Get Prefix (First 3 chars)
COLUMN Prefix = LEFT( SKU, 3 )
-- Scenario 2: Get Middle Code (Start at 5, take 4)
COLUMN Code = MID( SKU, 5, 4 )
-- Scenario 3: Get Country (Last 2 chars)
COLUMN Country = RIGHT( SKU, 2 )