Year(Month_Year) & ' Q' &Ceil(Month(Month_Year)/3) as Quarter
LOAD Date#(Month_Year,'MMM-YY') as Month_Year,
[.\Rolling Qtr test data.xlsx]
(ooxml, embedded labels, header is 2 lines, table is Sheet01);
I am using custom extension reporting viz lib with 72 Dimensions & 14 + measures with 7 time period combinations. there are lot of measures I have created like ytd,mat,mtd,qtd, roll 3 months,roll 12 months but stuck in growth calculation.
Hope you understand now.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution. If you want to go quickly, go alone. If you want to go far, go together.
Hi @vikasmahajan, sorry, I don't see why the Before() function wouldn't work, or an as-of calendar.
Another option I've used sometimes is to load all data adding one month or year to the date (in this case could be 3 months) and rename the values fields with _LM or _LY (or _LQ in this case), so the current data has access to last period data in the same dimensions. But with 72 dimensions I thik this solution can't be applied.
I would go to a solution similar to the as-of calendar or a date bridge.