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

Pragati11's avatar
Pragati11
Super 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...)

 

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Anonymous ,

     

    It doesn't seem to work. You have to create a free downloadable link.

     

    Thanks,

    Pragati

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi Anonymous ,

         

        Your .pbix is downloadable now.

        It has got so many file. 

        Which 2 datasets are creating relationship issues? Can you please name them here as in your .pbix file?

         

        Thanks,

        Pragati