Concatenate Year+Month

[rockam]

Hi Guys,

I´d like to create a new dimension, where I can connect two existed dimensions (year/month) and character ", " = for example 2021, Jun. 

Could I do it in calculate dimension by some formula, or should I solve it in the script?

Here I need to concatenate [MonthName] & [year]. 

LOAD
[year],
[month],
[date],
[currency],
Num#(impressions) as imp,
Month(Date#([month],'M')) as [MonthName]

Here [MonthName] is calculated based on this script: Month(Date#([month],'M')) as [MonthName].

The table view is just like below:-

Any help or suggestion on the script would be appreciated.

Thanks in Advance,

AK

[abhijitnalekar]

Try this,

LOAD
[year],

[year]&','& Month(Date#([month],'M'))  as MonthYear,
[month],
[date],
[currency],
Num#(impressions) as imp,
Month(Date#([month],'M'))  as [MonthName]

[rockam]

Hi - Can I sort this filter based on the newest to the oldest timeframe?

Please help here.

[jyothish8807]

You can sort by expression :

Max({1}Date)

[MayilVahanan]

Hi 

Try like below

MakeDate(Year, Month) as MonthName

and use that in filter