topic Re: Month to Quarter Mapping in App Development

Month to Quarter Mapping

AnushaKarthik — Tue, 08 Apr 2025 13:42:54 GMT

How can I get the below mapping in the data model?

For each As on Date, it should go back back to the last 4 quarters.

Re: Month to Quarter Mapping

rdm6532 — Tue, 08 Apr 2025 13:49:45 GMT

Here is an inelegant solution that should give you want you need:

Re: Month to Quarter Mapping

marcus_sommer — Tue, 08 Apr 2025 15:14:45 GMT

Maybe with an approach like this one:

load *, dual('Q' & ceil(month(TargetDate) / 3) & ' ' & year(TargetDate),
monthstart(TargetDate)) as Quarter;
load SourceDate, addmonths(Date, (iterno() -1) * -3) as TargetDate
from Source while iterno() <= 4;