Adding new column

[risabhroy_03]

I have a dimension named [Item] and I am picking [Item] based on a condition where two date fields are involved.

Ex- I am picking [Item] based on [ShipDate] and [ArriveDate].

I want a new column name Date where my ShipDate & ArriveDate should come in a single column.

For example - 

Company Code	Item	ShipDate	ArriveDate	Date
220	Pencil	10-11-21	12-11-21	10-11-21  12-11-21
240	Pen	01-11-21	06-11-21	01-11-21 06-11-21

Please help me.

[rbartley]

Hi,

Unless I'm missing something, you should be able to use =ShipDate&' '&ArriveDate.