Forum Discussion

tc97's avatar
tc97
Frequent Visitor
4 years ago
Solved

Calculated Column - DATEDIFF - Days Since Promo Start

Hi, 
I have two tables - one for sales, and one for promotions we run. 

 

Sales table includes following columns:

OrderIDOrderDatePromoCodeOrderValue

 

Promotions table consists of only two columns:

PromotionCodePromoStartDate

 

I'm looking to add a calculated column 'PromotionDay' to the Sales table to return how many days into the Promotion the order was placed. Is this relatively simple to calculate?

 

example below:

 

Promotion Table includes record: PromotionCode = 'SPRING22', PromoStartDate = '01 March 2022'

Sales Table would have the below record

OrderIDOrderDatePromoCodeOrderValuePromotionDay
00098705 March 2022SPRING22£150.995

 

Thanks in advance.

  • Hi tc97 
    Please try

     

    PromotionDay =
    DATEDIFF ( RELATED ( Promotions[PromoStartDate] ), Sales[OrderDate], DAY )

     

2 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion

    Hi tc97 
    Please try

     

    PromotionDay =
    DATEDIFF ( RELATED ( Promotions[PromoStartDate] ), Sales[OrderDate], DAY )

     

    • tc97's avatar
      tc97
      Frequent Visitor

      That was nice and easy! Thanks so much!!