Forum Discussion
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 😅.
if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.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.
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.