Forum Discussion

DJBAJG's avatar
DJBAJG
Icon for Helper IV rankHelper IV
5 years ago

Slice two tables by multiple common columns

I have two tables; Table A and Table B.   The tables have 3 common columns and many other non-common columns.   The tables cannot be combined.   What I need is the ability to create 3 slicers f...
Need Help
DJBAJG's avatar
DJBAJG
Icon for Helper IV rankHelper IV
5 years ago

Tell me more about creating a key. Would I concatenate the 3 common values into a column on the fact tables and on the bridge table and us that column to create the relationship? 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DJBAJG 

 

Why would you want to create a key that would be text? Keys are and should always be integers due to speed reasons (rarely GUIDS). If you only have unique combinations of 3 fields in a table (and they should be unique since it's going to be sort of a junk dimension), each such combination can be assigned an integer key. Then you should use this key in other tables. Creating such a table and assigning integer key, then placing them in the related tables is pretty easy in Power Query.

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

    Based on my previous response you can see that I'm new to the concept in general. Are you able to provide an small example of the query I would need to execute this so I can better understand the idea behind it and learn by expanding it to meet me needs? My DAX is weak and my M is non-existant. LOL