Filtering Sales between Notification Dispatch and Sales Time

Hi, I am having trouble trying to visualize the effects of the notification on Sales.

I have three tables of content:

One which describes the Notification and have the ID and the Dispatch time

One which has the NotificationID, UserID and Dispatch Status (this is if the user received or not)

One which I have Sales information including UserID and time

I would like to see the impact of number of sales and amount spent by the diference between the dispatch time and sale time. Also I would like to compare the sales between users that received the Notification or Not. Like how many users that received bought something and how many that did not received bought in the same time period.

For that I would like to Filter the sales by diferent diferences in time.

I am not an expert in Power Bi, actually I am pretty new to it. So I don't actually know many power query tools

Thank you

Need Help

sturlaws
6 years ago
Nice.

A couple of things. I suspect that these sample data are simplified, perhaps to much. As long as each customer only has 1 notification, the relationships are 1-to-many. But once you have a customer with more than 1 notification the relationships between the tables will be many-to-many. Many-to-many relationships are much more complex to handle than 1-to-many.

You wrote that you want to analyse on the difference in time between dispatch and sales. How should the difference be calculated when there are more than 1 sale?

You were also looking for the difference between sales to customers who received notification to those that don't. But your sample sales data does not contain any customers who did not reveice notification.

What you could do is to do some calculations on your sample data in Excel to describe you desired output.

If you are having problem sharing the data directly in the forum, you can upload the data to dropbox/onedrive/other, and share the link

Filtering Sales between Notification Dispatch and Sales Time.pbix450 KB