Evaluate sales in a campagin period

[Anonymous]

Hi all,

I have two tables.

A transaction table listing items, revenue, posting date and other categorizations such as price adjustment.

Then I have another table listing items, campaign code and start and end date. 

I would like to monitor the campaign item sales. Specifically see how much of the sales has been done with a price adjustment = "manually"  in the campaign period (because this shouldn't happen).

Campagin table:

a random test to illustra the problem

[v-shex-msft · Accepted solution]

Hi @Anonymous,

It seems like a common multiple date field analysis requirement, I'd like to suggest you take a look at below blog start end date part it helps:

Before You Post, Read This 

In addition, you can also consider creating a new table to expand and mapping the records:

Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community
Regards,
Xiaoxin Sheng

[amitchandak]

@Anonymous , One way is to create a new column in the campaign table from sales

example

sumx(filter(Sales, campaign [Business Unit] = sales[Business Unit] && campaign[Item] = sales[Items]

&& Sales[Sales Date] >= campaign[Start Date] && Sales[Sales Date]<= campaign[End Date]), Sales[Sales Amount])

and you can use that.

Or populate campaign ID in sales tables