Forum Discussion
Union two generated tables with different columns (not Query)
SOLUTION:
I had to make sure the two set of tables had the same column quantities and it worked.
Can you present the expected output? Have you looked at NATURALLEFTINNERJOIN and NATURALLEFTOUTERJOIN?
https://msdn.microsoft.com/en-us/query-bi/dax/naturalleftouterjoin-function-dax
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.