Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Using NATURALINNERJOIN function

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 tw...
HotChilli's avatar
HotChilli
Community Champion
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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