Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys ,
What expression can we use to calculate number of months in current quarter??
Hi,
Try like this
=Month(QuarterEnd(Today())) - Month(QuarterStart(Today())) + 1
Regards,
Jagan.
Have Proper Master calendar
Let varMinDate = num(MakeDate(2000,1,1));
Let varMaxDate = num(MakeDate(2020,12,31));
//*************** Temporary Calendar ***************
TempCalendar:
LOAD
$(varMinDate) + rowno() - 1 AS Num,
date($(varMinDate) + rowno() - 1) AS TempDate
AUTOGENERATE
$(varMaxDate) - $(varMinDate) + 1;
//*************** Master Calendar ***************
MasterCalendar:
LOAD TempDate AS Date,
Week(TempDate) AS Week,
Year(TempDate) AS Year,
Month(TempDate) AS Month,
year(TempDate)&'-'&Month(TempDate) as Year_Month,
MonthName(TempDate) as YearMonth,
Day(TempDate) AS Day,
'Q'&ceil(month(TempDate)/3) AS Quarter,
Month(TempDate)&'Q'&ceil(month(TempDate)/3) AS Month_Quarter
RESIDENT TempCalendar
ORDER BY TempDate ASC;
DROP TABLE TempCalendar;
Store MasterCalendar into MasterCalendar.qvd(qvd);
count (Month_Quarter) will give you all months in a specific quarter
Regards
ASHFAQ
Hi,
Try like this
=Month(QuarterEnd(Today())) - Month(QuarterStart(Today())) + 1
Regards,
Jagan.
=NUM(MONTH(Today())) -NUM(Month(QuarterStart(Today()))) +1