Goal: Standardize messy text input.
UPPER: Converts to ALL CAPS.
LOWER: Converts to lowercase.
Ready...
💻 DAX Formula
-- Scenario 1: Standardize Codes (All Caps)
COLUMN UpperCode = UPPER( Products[SKU] )
-- "iphone" becomes "IPHONE"
-- Scenario 2: Standardize Emails (Lowercase)
COLUMN CleanEmail = LOWER( Customer[Email] )
-- "John.Doe@Mail.Com" becomes "john.doe@mail.com"