Forum Discussion
Solved
Union two generated tables with different columns (not Query)
Hi, So I've got two tables which were generated through DAX. Table01 and Table02 I can't manage them via Query because they wer generated through DAX (correct?) So, I want to combine ...
SOLUTION:
I had to make sure the two set of tables had the same column quantities and it worked.
Hi Greg_Deckler,
I haven't tried NATURALLEFTINNERJOIN and NATURALLEFTOUTERJOIN.
Apparently it won't work because the tables have different columns (I might be wrong, sorry I am new to this).
According to msdm regards NATURALLEFTOUTERJOIN Function (DAX): "Only columns from the same source table (have the same lineage) are joined on."
Here is something similar to the output I am expecting:
Item Balance Month 78011 30 June 76898 50 July 76895 -10 July 76866 -50 August 76987 20 August 76988 30 September
*this is an example only, not related to the table calculations above*
As you can see, there is one line for each product (Item), with it's balance and month.
SOLUTION:
I had to make sure the two set of tables had the same column quantities and it worked.