Creating a Combined Column in DAX

Indeed, this is a simple and common task in DAX where we need to create a new column by combining two existing columns (in this case, "Itemno.1" and "Trim" from the "Label Reorder Summary" table). To combine two text fields, we can use the "COMBINEVALUES" function in DAX. Here's how you can create this calculated column:

// Add a new column named "Combined" to "Label Reorder Summary" table
Label Reorder Summary[Combined] = 
COMBINEVALUES(" - ", 'Label Reorder Summary'[Itemno.1], 'Label Reorder Summary'[Trim])

Let's break down the code:

COMBINEVALUES(" - ", 'Label Reorder Summary'[Itemno.1], 'Label Reorder Summary'[Trim]) creates a string by combining 'Label Reorder Summary'[Itemno.1] and 'Label Reorder Summary'[Trim] separated by " - ".

Label Reorder Summary[Combined] = assigns the result string as a new column "Combined" in the "Label Reorder Summary" table.

You can adjust the separator and columns to suit your needs. Ensure the 'Label Reorder Summary'[Itemno.1] and 'Label Reorder Summary'[Trim] columns exist in your 'Label Reorder Summary' table.

Please note: Make sure the 'Label Reorder Summary'[Itemno.1] and 'Label Reorder Summary'[Trim] columns are in text format. If not, you will need to convert them using the FORMAT function before combing them.

To further improve your DAX skills, you might want to consider taking additional courses on the Enterprise DNA Platform. They offer a wide range of tutorials and lessons on topics that will help enhance your professional development in the field.