Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Relationship with Unique Value

I am trying to create a relationship between two tables. I have tried to do this and I have been receiving the error "cant create a relationship between these two columns because one of the columns m...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    Anonymous,

     

    Enclose 1 with double quotes (").

    Column =
IF ( [Master Column] = "", "1", [Master Column] )
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
9 years ago

Anonymous

 

1. are they all the same case?

2. do you have any blank values?

 

power query  sees different cases as unique values, dax doesn't.  hence remove duplicates no working

also if there are blanks on the side that should be unique you need to pad them with a value like unknown or -1 or something similar.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I have one row that contains a blank value, How would I go  about padding this with a 1? I have tried to just create a new column by using:

=if([Master Column]="",1,[Master Column].

With this I am recieving an "Expressions that yield a varient data-type cannot be used to define calculated columns" error. 

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Anonymous IF ( ISBLANK ( [Master Column] ), 1, [Master Column] )

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      The formula returns the same error that I was returned previously for me.

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Icon for Community Support rankCommunity Support
        9 years ago

        Anonymous,

         

        Enclose 1 with double quotes (").

        Column =
IF ( [Master Column] = "", "1", [Master Column] )