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
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Power BI Monthly Update - June 2024
Check out the June 2024 Power BI update to learn about new features.
Fabric Community Update - June 2024
Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.
