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 I can share a file, but can you let me know how...I don't see the option

Or share your email address.

 

Thanks a lot for your help! This is really nice to have the ability to share knowledge like that!!

 

PY

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

Hi Anonymous ,

 

You can upload the .pbix file on your drive and create a sharable link. That link can be shared here.

 

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Let's try that 😉

    Text join 

     

    Tell me if it works ( I ma not really used with OneDrive...)