Hi @jakeudy
There are multiple ways to produce your required output. In addition to the elegant dax solution provided by @Daniel29195 , let me also provide alternative method which uses power query as well as dax to produce your requried output.
In order to create different rows for multiple quantities, you can create add column for each multiple quantities and unpivot those added columns. (The way I did it is not so efficient as you have to add column one by one for additional multiple quantities, and there's probably quicker way to do this as well as ensuring that the model still works for quantities over 5).
Then you add an index column and a modulo to identify multiples of 3, such as 3, 6, 9, 12, and so on, then do fill up, and divide that by 3 to get the 111, 222, 333, 444, and so on.
After that, you can summarize that column using dax and reference the minimum week number from the calendar table, and the resultant output will look like below.
I attach a pbix file as an example.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
