Forum Discussion

Dhjlm's avatar
Dhjlm
Frequent Visitor
5 years ago
Solved

Problem with unique values

I have a table of shipments statistics 'Query 1', and a table with distances from our warehouse based on postnumbers 'Rev 202011'. I'm trying to create a relationship between the postnumbers ('query...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Dhjlm ,

     

    In addition to what Greg_Deckler mentioned in his response, do check if there are NULL values in the columns that you are trying to create relationship on. ('query1[POSTNR3] and 'Rev 202011'[Postnr] in your case)

    I have experienced similar error in the past due to the NULL values in the key columns that are used for creating the relationships between two tables.

     

    Thanks,

    Pragati

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Dhjlm You should be able to create a many-to-many relationship although that is generally not ideal. You can use DISTINCT to get a table of unique values that you could use as a bridge table. But, sample data and such would be very helpful to try to see what you are trying to accomplish. 

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.