Promotions

[EzadineAlwajeeh]

Hello, I have a Promotions table with the following columns: City Name, Product Type, Promotion Start Date, Promotion End Date, and Promotion Value. I also have a Sales table with the following columns: City Name, Product Type, Goods Entry Date to the factory with date and time, Goods Exit Date from the factory with date and time, Good Value, Customer Name, and Customer ID. My question is that I want to calculate the promotion value for each Good, with several conditions. Each city and product type has its own specific promotions, and if the current promotion is greater than the previous promotion, the start date of the current promotion begins from the goods exit date at 12 PM. If the current promotion is smaller than the previous promotion, the start date of the goods begins from the goods entry date at 7 AM. I need a DAX formula to add a column to calculate the promotion value for each Good in the Sales table. Thank you.

[dilistimor]

Hello @EzadineAlwajeeh

Is it "offer" column that you mean with promotion?, I will work on it. 

First you have to find the relation between those 2 tables because you mention the start that refers to entry date or exit date of the good (table #2) 

[EzadineAlwajeeh]

yes, I mean promotion. can you help me how to solve it

[danextian]

Hi @EzadineAlwajeeh ,

As always please provide a workable sample data that can be pasted to Excel (not an image) and your expected result using that sample data. You can post a link to an Excel file in the cloud (Google/OneDrive/Dropbox, etc) or a sanitized copy of your pbix. Please refer to this stickY post. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...