Formula for new column

Hi Harish85,

The easiest way is to use DAX:

• Go to Data view
• Select your table ZZK1LTSD0074K
• Click New Column
• Paste the formula 
• Rename the column if needed

Description = 
SWITCH(
    'ZZK1LTSD0074K'[zz_partner_type],
    "RE", "BILL TO",
    "RG", "PAYER", 
    "WE", "SHIP_TO",
    "EL", "END USER LOC",
    "EU", "END_USER",
    "ZK", "DIST",
    "ZR", "RESELLER",
    "Unknown"  -- Default value for any unmatched partner types
)

But if your dataset is Large You should use Power query:

• Go to Power Query Editor
• Select your table
• Add Column → Conditional Column
• Set up the conditions:

Column Name: Description
If [zz_partner_type] = "RE" then "BILL TO"
Else If [zz_partner_type] = "RG" then "PAYER" 
Else If [zz_partner_type] = "WE" then "SHIP_TO"
Else If [zz_partner_type] = "EL" then "END USER LOC"
Else If [zz_partner_type] = "EU" then "END_USER"
Else If [zz_partner_type] = "ZK" then "DIST"
Else If [zz_partner_type] = "ZR" then "RESELLER"
Else "Unknown"

• Don't forget to Refresh data after using Power query 😅.

I’ve done something similar 🙂. You’ve got two good options:

Option 1: DAX calculated column with SWITCH
Go to Modeling → New column and use:

Description =
SWITCH(
    [zz_partner_type],
    "RE", "BILL TO",
    "RG", "PAYER",
    "WE", "SHIP_TO",
    "EL", "END USER LOC",
    "EU", "END_USER",
    "ZK", "DIST",
    "ZR", "RESELLER",
    BLANK()    // default
)

This will create the new Description column right next to your Partner type.

Option 2 (cleaner for long-term):
Make a small 2-column table (Partner type ↔ Description) and relate it to your main table. That way, if you ever add more partner types, you only update the mapping table instead of editing the DAX formula.

👉 Tip: If you just need a quick fix, go with SWITCH. If you want scalability, build the small mapping table.

I’ve done something similar 🙂. You’ve got two good options:

Option 1: DAX calculated column with SWITCH
Go to Modeling → New column and use:

Description =
SWITCH(
    [zz_partner_type],
    "RE", "BILL TO",
    "RG", "PAYER",
    "WE", "SHIP_TO",
    "EL", "END USER LOC",
    "EU", "END_USER",
    "ZK", "DIST",
    "ZR", "RESELLER",
    BLANK()    // default
)

This will create the new Description column right next to your Partner type.

Option 2 (cleaner for long-term):
Make a small 2-column table (Partner type ↔ Description) and relate it to your main table. That way, if you ever add more partner types, you only update the mapping table instead of editing the DAX formula.

👉 Tip: If you just need a quick fix, go with SWITCH. If you want scalability, build the small mapping table.