Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 only two columns:
PromotionCode | PromoStartDate |
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
OrderID | OrderDate | PromoCode | OrderValue | PromotionDay |
000987 | 05 March 2022 | SPRING22 | £150.99 | 5 |
Thanks in advance.
Solved! Go to Solution.
Hi @tc97
Please try
PromotionDay =
DATEDIFF ( RELATED ( Promotions[PromoStartDate] ), Sales[OrderDate], DAY )
Hi @tc97
Please try
PromotionDay =
DATEDIFF ( RELATED ( Promotions[PromoStartDate] ), Sales[OrderDate], DAY )
That was nice and easy! Thanks so much!!
User | Count |
---|---|
51 | |
38 | |
20 | |
14 | |
13 |
User | Count |
---|---|
98 | |
71 | |
29 | |
20 | |
13 |