Column to change value names

[Lamda]

Hey All,

So I have a simple column called Product and it has the values:

Honda 31J Accord LX Tint with spoiler
Toyota 555 Camry spoiler 4x4 XI
Ford 890 Focus blue leather CI

I want to create a short name or friendly name for these so I want to create a new column in PPivot using DAX to say set the new names to

Honda 311 LX
Toyota 555 XI
Ford 890 CI

I think it needs to be a calculate function that would say if Calculate(IF(Product = "Honda 31J Accord LX Tint with spoiler",(then set it to "Honda 311 LX") but I can't seem to figure out the formula for this.

Thoughts?

Thanks!

 

[Matt Allington]

You should do this in your source table ideally. If you can't, you could do the following.

1. create a new linked table in Excel. Add the current column and the new column in this table
2. load the new table to the data model and join the tables on the common current column. Current table on the many side of the relationship, new table on the one-side.
3. Bring the new column of data from the new table into the current table with a calculated column using RELATED().