Good evening and impressive amount of advise and training materials that you have produced.
Sam, hoping you can help me with my issue.
** Modified excel file from Enterprise DNA Demo.
Adi_EnterpriseDNAFreeTrainingDemoData.xlsx (80.1 KB)
The attached Excel file provides details of the issue outlined below.
In many companies the Promotion information and Sales History information are not combined resulting in Promotion ID code not carried in the Sales Data table. This results in Promotion performance analysis being done via complex programming of hard coded reports.
Include the Promotion ID in the Sales Data table making it easier to analyze in Power BI.
Need to include a Promotion ID into the Sales Data table based on Multiple criteria: Dates, Product and Location. These criteria are provided in new Promotion related tables: (a) Promotion ID, Dates and Discount (b) Products on Promotion © Location on Promotion.
(a) Do not know how to include multiple criteria in new Calculated column using DAX.
(b) Also unclear how to use the Date Range within a Calculated column.
Thanking you in advance for all your help.
Best regards…Adi K. Asavaid