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