https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-DATEDIFF-Days-Since-Promo-Start/m-p/2539664#M71500 <P>That was nice and easy! Thanks so much!!</P> Wed, 25 May 2022 17:18:33 GMT tc97 2022-05-25T17:18:33Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-DATEDIFF-Days-Since-Promo-Start/m-p/2538784#M71454 <P>Hi,&nbsp;<BR />I have two tables - one for sales, and one for promotions we run.&nbsp;</P><P>&nbsp;</P><P>Sales table includes following columns:</P><TABLE border="1"><TBODY><TR><TD>OrderID</TD><TD>OrderDate</TD><TD>PromoCode</TD><TD>OrderValue</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Promotions table consists of only two columns:</P><TABLE border="1"><TBODY><TR><TD>PromotionCode</TD><TD>PromoStartDate</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>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?</P><P>&nbsp;</P><P>example below:</P><P>&nbsp;</P><P>Promotion Table includes record: PromotionCode = 'SPRING22', PromoStartDate = '01 March 2022'</P><P>Sales Table would have the below record</P><TABLE border="1"><TBODY><TR><TD>OrderID</TD><TD>OrderDate</TD><TD>PromoCode</TD><TD>OrderValue</TD><TD>PromotionDay</TD></TR><TR><TD>000987</TD><TD>05 March 2022</TD><TD>SPRING22</TD><TD>£150.99</TD><TD>5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance.</P> Wed, 25 May 2022 12:30:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-DATEDIFF-Days-Since-Promo-Start/m-p/2538784#M71454 tc97 2022-05-25T12:30:40Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-DATEDIFF-Days-Since-Promo-Start/m-p/2538968#M71468 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="382568" data-lia-user-login="tc97" class="lia-mention lia-mention-user">tc97</a>&nbsp;<BR />Please try</P><P>&nbsp;</P><LI-CODE lang="javascript">PromotionDay = DATEDIFF ( RELATED ( Promotions[PromoStartDate] ), Sales[OrderDate], DAY )</LI-CODE><P>&nbsp;</P> Wed, 25 May 2022 12:59:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-DATEDIFF-Days-Since-Promo-Start/m-p/2538968#M71468 tamerj1 2022-05-25T12:59:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-DATEDIFF-Days-Since-Promo-Start/m-p/2539664#M71500 <P>That was nice and easy! Thanks so much!!</P> Wed, 25 May 2022 17:18:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Calculated-Column-DATEDIFF-Days-Since-Promo-Start/m-p/2539664#M71500 tc97 2022-05-25T17:18:33Z