Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
I am able to split my data in Month and Year on using...
Load Date,
Month (Date) as Month,
Year (Date) as Year,
from
FROM
(biff, embedded labels, table is Fact$);
But plz tell me the command by which i can devide the Date or Year Columns in 4 Quarter[Q1(jan-march),Q2(april-jun),Q3(july-sep),Q4(oct-dec)] .
Regards,
Rahul
Hi Rahul,
Try this:
Load Date,
Month (Date) as Month,
Year (Date) as Year,
'Q' & CEIL(MONTH([Date])/3) as Quarter
FROM
(biff, embedded labels, table is Fact$);
Hope this help.
Regards,
Sokkorn
Hi Rahul,
Try this:
Load Date,
Month (Date) as Month,
Year (Date) as Year,
'Q' & CEIL(MONTH([Date])/3) as Quarter
FROM
(biff, embedded labels, table is Fact$);
Hope this help.
Regards,
Sokkorn