Forum Discussion

Sibrulotte's avatar
Sibrulotte
Icon for Helper IV rankHelper IV
6 years ago

Default 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 ot...
Need Help
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
6 years ago
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's avatar
Sibrulotte
Icon for Helper IV rankHelper IV
5 years ago

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.

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    5 years ago
    Sibrulotte 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's avatar
      Sibrulotte
      Icon for Helper IV rankHelper IV
      5 years ago

      Hi, unfortunatly, it is not a one to many relation.

       

      Envois _Qv contains many communications, and for every communication there are many recipient emails (NEP is the field in this case linking to my transactions).

      And my transactions (Rentrées_de_fonds_FF) can have many transactions for the same email/NEP.

       

       

       

      • Sibrulotte's avatar
        Sibrulotte
        Icon for Helper IV rankHelper IV
        5 years ago

        Too late for a follow up? 🙂