Forum Discussion
Helper IVDefault date in slicer
hi,
i've seen a few posts about default slicer values, but none that would help in my scenario.
I have two tables, one with a list of emailing sendouts, email, and the date it was sent.
the other is a transactions table with sales per email, the date of the transaction and the amount.
Sendout:
Email, Date, Sendout_name
Transactions:
Email, Date, amount
The key is done on emails, and emails only.
I'd like to show a sum of amount, but with transaction date slicer starting at the date of the sendout.
is that possible?
9 Replies
- AllisonKennedy
Community Champion
Is it a 1 to many relationship? You can do it if so and with a Date table that only filters the SendoutDate and does not filter or have relationship to Transactions date.- Sibrulotte
it is a 1 to many relatinship.
Do you have any links to show me what you are refering to?
- Sibrulotte
btw AllisonKennedy , I'm very thankfull for the attention you brought to my post 🙂
I'm just to familiar with the solution you're refering to.
- AllisonKennedySibrulotte please can you share here a screenshot of your model view with relationships, and also click on Manage Relationships and share a screenshot of that so I can see what columns are related between each tables. Once I see what you have done so far, I can advise how I would change it.
You should have a date table in your data model too: https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html
- Sibrulotte
hoping for a taker on this 🙂
