Setting a date Format

[#1]

I have some data in a field called Month.  It has the format of    'MMM YY   Example:

'Apr 17

'Feb 17

'Jan 17

I would like to use these as month reporting

the ' is part of the actual data

can someone help

[kaushiknsolanki]

Hi,

Not sure what you are looking?

Kindly explain with example.

Regards,

Kaushik Solanki

[Anil_Babu_Samineni]

May be one possible solution is this?

LOAD FieldName, Month(Date#(Replace(FieldName, Chr(39), ''),'MMM YY')) as FieldName2;

LOAD * Inline [

FieldName

'Apr 17

'Feb 17

'Jan 17

];

Create Tabular table with FieldName2 as dimension and metric for expression

[antoniotiman · Accepted solution]

Another way

MonthName(Date#(DateField,Chr(39)&'MMM YY'))