I have some data in a field called Month. It has the format of 'MMM YY Example:
I would like to use these as month reporting
the ' is part of the actual data
can someone help
Not sure what you are looking?
Kindly explain with example.
May be one possible solution is this?
LOAD FieldName, Month(Date#(Replace(FieldName, Chr(39), ''),'MMM YY')) as FieldName2;
LOAD * Inline [
Create Tabular table with FieldName2 as dimension and metric for expression