cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ggilmoreatu Regular Visitor
Regular Visitor

Promotional Analysis / Grouping Weeks / Cumulative Total

Hello,

 

I'm trying to run a promotional analysis where each customer's promotion is running at a different time frame. I will need to measure the run rate of sales for the time leading up to the promotion vs the actual promotion and see what the incremental lift was. I don't know if the best way to perform this is a formula, measure or grouping. The chart below will add some color.

 

Promotion.JPG

 

While a much smaller scale this shows what I need to pull off. For example customer A, B and C all have different timings of the promotion and Customer A is running from week# 201801-201804 while Customer B may be running from week 201803-201807.

 

What is the best way to group customer and have essentially a time frame for the promotion and non promotion?

 

Any help would be greatly appreciated.

 

Thanks,

 

Garrett

2 REPLIES 2
Community Support Team
Community Support Team

Re: Promotional Analysis / Grouping Weeks / Cumulative Total

Hi @ggilmoreatu

I need more information.

 

the "POS sales" means:

whether the customer runs promotion or not, finally they will contribute such sales,

right?

 

But you say eg. Customer A is running from week# 201801-201804 while Customer B may be running from week 201803-201807, 

if my understanding about "POS sales" is right, then "POS sales" in 201805-09 for Customer A are not for the promotion.

 

"run rate of sales for the time leading up to the promotion vs the actual promotion and see what the incremental lift was."

what is "actual promotion" and "rate of sales for the time leading up to the promotion"?

 

Best Regards

Maggie

 

 

ggilmoreatu Regular Visitor
Regular Visitor

Re: Promotional Analysis / Grouping Weeks / Cumulative Total

POS Sales stands for Point of Sale Sales... Meaning just sales: The toal number of sales across that given timeframe.

 

Yes whether the customer runs promotion or not they will have sales just in theory the promotion sales should be higher.

 

Yes your understanding is correct 201805-201809 for Customer A is not in the promotion.

 

Actual promotion is the dates listed that the promotion is running and the rate of sales leading up to the promotion would be all sales outside of the promotion (it needs to be a cummulative running total as well) in order to see the effect of the promtion vs non promotion sales.

 

Example: Customer A 201801-201804 = Promotion

201805-End = Non Promotion.

 

 

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 226 members 2,746 guests
Please welcome our newest community members: