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: OrderID OrderDate PromoCode OrderValue   Promotions table consists of ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi tc97 
    Please try

     

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

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi tc97 
Please try

 

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

 

tc97's avatar
tc97
Frequent Visitor
4 years ago

That was nice and easy! Thanks so much!!