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
Hi,
Not sure what you are looking?
Kindly explain with example.
Regards,
Kaushik Solanki
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
Another way
MonthName(Date#(DateField,Chr(39)&'MMM YY'))