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).
a random test to illustra the problem
Go to Solution.
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 CommunityRegards,Xiaoxin Sheng
View solution in original post
@kolovez , One way is to create a new column in the campaign table from sales
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
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!