Forum Discussion
Sibrulotte
Helper IV
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 ot...
SibrulotteHelper IV
Helper IVHi, 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.
SibrulotteHelper IV
Helper IVToo late for a follow up? 🙂
- Sibrulotte
AllisonKennedy I guess many to many relationships won't allow for your solution to work?
- AllisonKennedy
Community Champion
It looks like you're doing reporting on many fact tables, so you need to connect them all using Dimension tables. In your case you'll need a DimNav that has each NAV exactly once. Use that to connect the two fact tables envois and reentre.
I'm not sure how advanced your knowledge of relationships in Power BI is, but I've written these posts to help explain why many to many should be avoided: https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power.html
https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power_11.html
https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power_92.html
You will also need a DimDate table connected to all the tables with dates.
