// Example 1: Orders table — ProductCategory | SubCategory // Table: Orders | Column One: ProductCategory | Column Two: SubCategory | Separator: " | " Orders[Display Label] = VAR vPartOne = TRIM(Orders[ProductCategory]) // Trim whitespace from the first column value VAR vPartTwo = TRIM(Orders[SubCategory]) // Trim whitespace from the second column value VAR vCleanOne = IF(ISBLANK(vPartOne) || vPartOne = "", "", vPartOne) // Return empty string if first part is blank, otherwise keep value VAR vCleanTwo = IF(ISBLANK(vPartTwo) || vPartTwo = "", "", vPartTwo) // Return empty string if second part is blank, otherwise keep value VAR vLabel = SWITCH( TRUE(), vCleanOne <> "" && vCleanTwo <> "", vCleanOne & " | " & vCleanTwo, // Both parts present: join with separator vCleanOne <> "", vCleanOne, // Only first part present: return it alone vCleanTwo <> "", vCleanTwo, // Only second part present: return it alone BLANK() // Neither part present: return blank ) RETURN vLabel