Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Unable to create a relation between text fields

Dear experts,   I am facing a strange issue. I have 2 excel files as sources.  - the first one is a the transaction data of sales data. One of the fields (StellinID) is the location of the goods,...
Need Help
Tips and Tricks
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi Anonymous ,

     

    1. You relationship netween the tables "Sales by Day" and "Stelling_Master_data" on column "StellinID" is perfectly right.

    2. In you .pbix file on "Page1" tab, 3rd table on the right, you have moved Stellin Id from both the tables but you get blank data for StellinID from "Stelling_Master_data" against the StellinIDs coming from "Sales by Day". The reason for this is, these StellinIds don't exist in your "Stelling_Master_data".

     

    Unique StellinId count in "Stelling_Master_data" = 136

    Unique StellinId count in "Sales by Day" = 16

    There exist no common "StellinIds" in these two tables.

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes sorry, I am jumping between subjects

 

If you look at Page 1 : the three tables are showing thr Stelling Id 

- From Sales by Day (table on the left)

- From Stelling Master data (table in the middle)

- the effect with the relation ship

 

If you look at the relationship manager, the relation that I want to work is between Sales by Day table and Stelling_Master_data on field StellingID and StellinID 

 

So far, I don't see why, the join des not work

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

1. You relationship netween the tables "Sales by Day" and "Stelling_Master_data" on column "StellinID" is perfectly right.

2. In you .pbix file on "Page1" tab, 3rd table on the right, you have moved Stellin Id from both the tables but you get blank data for StellinID from "Stelling_Master_data" against the StellinIDs coming from "Sales by Day". The reason for this is, these StellinIds don't exist in your "Stelling_Master_data".

 

Unique StellinId count in "Stelling_Master_data" = 136

Unique StellinId count in "Sales by Day" = 16

There exist no common "StellinIds" in these two tables.

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

     

    Well, ok, the issue is between the keyboard and the chair 😉

     

    Actually, my brain can read VKPSR028 and VPKSR028, and this sthe same...

     

    Thanks for the realignment 😉 And sorry for my dumb question

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    HI Anonymous ,

     

    No question is a dumb question. 🙂

     

    Keep learning! Keep Exploring New!

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati