Forum Discussion
Create a Launch Calendar Based on a Single Launch Date
Hi Anonymous - on the table with the order data, create a calcaulated column as "Days since Launch"
"Days since Launch" = DATEADIFF( RELATED ( "Item Master"[Launch Date] ), Order[Order Date], DAY)
Use that column as your X-axis, and the product ID / name as your legend. You'll get something like this:
Hope this helps
David
Community ChampionHi Anonymous - you can still use the Days Since Launch in this regard. Just think of 12 months as 365 days. Something like the below:
Rolling 12 Month Units =
CALCULATE(
[Total Units],
FILTER(
ALLEXCEPT( Items, Items[Item Number] ), //We are calculating per item
AND(
Orders[Days Since Launch] <= MAX( Orders[Days Since Launch] ),
Orders[Days Since Launch] > MAX( Orders[Days Since Launch] )-365
)
)
)
The ALLEXCEPT may need to change based on how you want to be showing the "Rolling 12" and possibly based on how [Total Units] is coded. If the above doesn't work, please share a pbix so I can be sure to use your tables and your model.
Hope this helps
David
Got it, I will try a few things and see if I can get it to work. Thank you for your responses