Forum Discussion
Filtering Sales between Notification Dispatch and Sales Time
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
Hi bcosta98,
your question is well written, but it will be much easier to help you if you add some sample data, or a sample report.
Cheers,
Sturla
Hi sturlaws
This are the tables
Notification
Sales
Notification_User
And the relations goes as follows:
Notification 1:* Notification_UserNotification_User *:1 User
User 1:* Sales
Hi bcosta98 ,
To create relationship between tables should help you in your scenario.
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
Could you attach your sample data as file(s)? It will save me the time of typing all the data.
