Month in number

[OS92]

Hello everyone,

have anybody a solution for my problem? 

I need a diagramm with month & year in the form mm/yyyy. As example 02/2021.

In my case, the month is a text and not a number. Is there any function to change the name into a number?

Thanks.

[Henri_Rufin]

I suggest to create a mapping table you will use then in your model to turn your text into number. 

MONTH_MAPPING:

MAPPING LOAD * INLINE
[
MONTH_MAPPING-FROM,MONTH_MAPPING-TO
Jan,1
feb,2
mar,3
...

];

Then apply the following
Subfield(“Field”,’ / ‘,1)&” / “ &ApplyMap(‘MONTH_MAPPING’ , subfield(”Field”, ‘ / ‘ ,2)) as Field

[Ksrinivasan]

hi,

in dimension

=Num(Month(Dateoo))&'/'&Year(Dateoo)

ksrini

[Vegar]

If you have a date field then you can create this field by using date() formating function.

Date(monthname(DateField),'MM/YYYY') 

With this method you won't get the same issues getting the sorting correct as it will sort chronological and not alphabetical per default.