Visualization tip to see how promotions or discounts made vs sales affect

[Syndicate_Admin]

Good, I wanted to know if you can advise me on how to see how discounts made on products affect when analyzing sales.

Regarding the promotions I have data of: name of the promotion, % discount, start date, end date

Regarding sales I have data on: date of completion, products sold, price per unit,.....

The promotion applies to all products regardless of whether it is in force.

From already thank you very much!

[grantsamborn]

Hi @fedemartin94  / @Syndicate_Admin 

I would like to help but I'm a little unclear about your requirements.

Can you show the following?

1)  Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

2) Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

3) Please explain how you would expect to get from 1) to 2)

I hope this helps.

Grant