i have a Time Period(YYYYMM) in my data in that i want to filter Time Period into
"Month Year" like Jan2017..etc and
"Quarter Year" like Q12017,Q22017..etc
please help on this
Thanks in advance.
Try with this
Date(Period,'MMM-YYYY') as [Month Year]
'Q' & ceil(Month(Period)/3)&Year(Period) as [Quarter Year]
Hi V Kumar...
Month&''&year as MonthYear,
'Q' & ceil(Month(TRANDATE)/3)&year as [Quarter Year];
year(TRANDATE) as year,
Month(TRANDATE) as MonthYear
Check the attached hope you are looking for this.
Retrieving data ...