Using NATURALINNERJOIN function

[Anonymous]

Hi,

in a my pbix, I'm trying to use the NATURALINNERJOIN function.

I've created manually a table named A, with two columns, Date and Value, and I've created manually a second table named B, with two columns, Date and Value. Moreover, I've created a (1-to-1, both) relationship between the A and B tables by the Date column.

When I've tried to create a test table with this dax expression: NATURALINNERJOIN(A,B) I've obtained this message error: the Date column already exists in the Test table.

Any suggests to me in order to solve a such issue, please? Thanks

[HotChilli]

You can get some strange error messages when using NATURALINNERJOIN.  They are usually to do with the concept of data lineage (and relationships between tables can affect the issue).

There are ways around it but may I ask whether you are just testing NATURALINNERJOIN or is it possible to do the join in Power Query which will probably be easier? 

[Anonymous]

Hi,

in the real scenario, to produce the A and B tables I need to accomplish more Power Query steps.

I'd like to avoid to generate a calculated table using Power Query so I'd like to maintain the etl logics at a level relatively complex.

Now, I'm trying to use the NATURALINNERJOIN with a two more simple tables with two only columns. These two tables were created manually without importing data from any data sources, the columns have the same name and data type. Could having a relationship be a problem? How can I use this dax function?

However, it is strange that using the NATURALINNERJOIN function could cause any issues. Is it a dax function with any bugs to solve?

Thanks