Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

NATURALINNERJOIN function doesn't work matching a text column

Hi, in a my pbi model I need to create a new table by DAX to match some columns of two tables created after more power query logics. In order to accomplish a such task I've used the NATURALINNERJOI...
  • dedelman_clng's avatar
    dedelman_clng
    5 years ago

    Hi Anonymous -

     

    I cannot replicate your results. Perhaps I don't have the correct data in Tab_A and Tab_B?

     

    Tab_A

    Codeobs_value

    aaaa 1
    bbbb 2

     

    Tab_B

    Codeexp_value

    aaaa 3
    bbbb 4
    cccc 5

     

    TAB_B_A_JOIN (copied your code directly from the post)

    CodeExpected valueObserved value

    aaaa 3 1
    bbbb 4 2

     

    If that is not the correct source data, please clarify.  Perhaps there are relationships you're not aware of that may be affecting your results?

     

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous -

 

I cannot replicate your results. Perhaps I don't have the correct data in Tab_A and Tab_B?

 

Tab_A

Codeobs_value

aaaa 1
bbbb 2

 

Tab_B

Codeexp_value

aaaa 3
bbbb 4
cccc 5

 

TAB_B_A_JOIN (copied your code directly from the post)

CodeExpected valueObserved value

aaaa 3 1
bbbb 4 2

 

If that is not the correct source data, please clarify.  Perhaps there are relationships you're not aware of that may be affecting your results?

 

Hope this helps

David

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, thanks for your reply.

    I've discovered some errors in data for Tab_A and Tab_B, sorry.

    It seems that the NATURALINNERJOIN functions rightly as you have indicated.

    Many thanks and bye