Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date string concatenation

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.

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

3 Replies
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

Not applicable
Author

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