Date string concatenation

[#1]

Hi,

I have several Dates in my model (5 calendars).

Date_1, Date_2, Date_3...

I have a field that's indicate what type of date we work by,

the field called DatePick and he's containing 1 to 5.

I want to concatenate him in my dimensions.

So the dimension will look like this: Date_&DatePick or Month_&DatePick.

What is the proper way to achieve that?

Thanks for help, sorry for bad english.

[marcus_sommer]

Have you checked if it's possible to merge some or all calendars into a canonical-calendar: Canonical Date? Your usage of DatePick and a possible concatenating it with date-fields into a dimension isn't quite clear for me what is the aim for it?

- Marcus

[#3 · Accepted solution]

I managed to solved it!

I've  created a variable and set it to: ='Month_'&DatePick

and in the expression i put: =$(vMonth)

worked.

Thanks Marcus for your will to help.

Have a nice day.

[Digvijay_Singh]

You may need to use calculated dimension as Date & '_' & DatePick and Month & '_' & DatePick