1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combine Two Source Tables with Different Relationships in dimension table columns

Discussion in 'Power Pivot, Power Map etc' started by dilawer5, Oct 4, 2017.

  1. dilawer5

    dilawer5 New Member

    Messages:
    22
    A formula or a way through which two sources should act like one source table.

    upload_2017-10-4_13-1-13.png

    Regards
  2. dilawer5

    dilawer5 New Member

    Messages:
    22
    Dear Dilawer!

    First you need to understand that both source tables should be linked with all tables.

    1. For this you first merge Customer table & Distributor table by adding helper column (Customer name& Distributor Name)

    2. Secondly you need to add helper columns in both sources which is (item code& item name.

    Now data is shaped better. While merge two source table in power query then add helper column which has filter primary and secondary sales.

    Hope you understand.
  3. dilawer5

    dilawer5 New Member

    Messages:
    22
    Thank You Dilawer, But I dont want to merge both source tables
  4. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,669
    Thomas Kuriakose likes this.
  5. Chihiro

    Chihiro Well-Known Member

    Messages:
    3,669
  6. dilawer5

    dilawer5 New Member

    Messages:
    22
    Yes, I looked my question from an expert view and a thought to share it may be it help others. Thank you Chihiro as ever you are there to help.
  7. r2c2

    r2c2 Active Member

    Messages:
    118
    @dilawer5

    First up, stop talking to yourself in public. :D
    Jokes aside, I think a better option is to combine two tables to one using either Power Query or Combine DAX function. You may also add a type column in source tables to distinguish tables. Then set up star schema (ie just connect the dimension tables to single fact) and use CALCULATE to filter your measures by either table values.

    If you wish to retain both tables, you can use the excellent USERELATIONSHIP() to define which relationship should be used when defining the filter context for the measure.

    Hope that helps.

Share This Page