Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create a Launch Calendar Based on a Single Launch Date

I have a model that consists of a fact table that includes individual orders, a date table, and an Item Master table that includes all items and includes a column that defines the first date that eac...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    6 years ago

    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

     

     

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
6 years ago

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

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

dedelman_clng This does seem to work for all of the measures that sum up value columns on my fact table, which is great. I had also set up measures to calculate Rolling 12 month totals based off of this formula that I had found somewhere:

Rolling 12 Month Units = 
    CALCULATE(
        [Total Units],
        FILTER(
            ALL( 'Calendar' ),
            AND(
                'Calendar'[Date] <= MAX( 'Calendar'[Date] ),
                DATEADD( 'Calendar'[Date], 1, YEAR ) > MAX( 'Calendar'[Date] )
            )
        )
    )

It looks like this does not work with the Months Since Launch, would you have any suggestions for a better formula? I tried changing all of the dates in the formula to the connected column from the fact table, but it doesn't look like that is calculating correctly.