One-to-One Relationships - The Whiteboard #11
Vložit
- čas přidán 20. 07. 2024
- The one-to-one relationship is just a particular type of one-to-many relationship...
Learn abstract DAX concepts in a more interactive way with "The Whiteboard" series. Read more: www.sqlbi.com/blog/marco/2022...
#thewhiteboard - Věda a technologie
Oh thank goodness - i spent 8 minutes wondering why they were two separate tables in the first place :D
Great video! Should do a whiteboard session on circular dependencies in the future
Great! Thanks a lot Marco, this was just what I needed!
Good Explanation. Thank-you
It (almost) always comes down to a good model.
Very nice 👍👍👍👍🙂
I use 1-to-1 relations to extend a table from a published dataset (accessed via a direct query connection) with additional fields
It makes sense for composite models, indeed.
Would you be willing to do a video on how to resolve two fact tables connected to one dimension table, but one fact table does not connect to several other dimension tables. As of now I only could connect the facts tables with a many to many pairing..which worked. But this cannot be best practice can it? I also see no way to connect the other dimension tables to the one fact table ins sql. The reason this is relevant is because I need to do a calculation using both fact tables.
Wait for the next Whiteboard episode about many-to-many relationships! In less than two weeks...
Why did it use two FKs instead of only one ProductKey?
Srr bro but i have to say this. Please stop using so many bodylanguages when u try to say something. I really believe you have something usefull to say, but i keep getting distracted by ur overexagerrated bodylanguage. Chillax bro, dont be so scared that people won't understand you. Peace.
Unfortunately, I was on a chair.
When I stand up, I also walk back and forth, increasing the noise in the communication!
Sorry, it's hard to reset to the default factory settings now.
Peace and love!