Forum Discussion
Union Formula mixes columns
just a guess, in your dax union formula, maybe try no to reference the table directly, bu use something like
union (summarize(table_current, field1,field2),summarize(table_history,field1,field2))
Ah, so you are using DAX UNION formula to combine the two tables. I never used this function but used Append Queries in data model
Did you tried that?
- Click Edit Queries
- Append Queries
here is similar question in the past on this forum
https://community.powerbi.com/t5/Desktop/union-formula-column-section-error/td-p/80004
I have seen that and tried but then i got another error message after a long loading time. Also i had the feeling that with append queries it loads both tables from the datawarehouse. I will try again later and see if it works...
Sure, interested to see how this get resolved? Will be good for other users as well.
first of all - HAPPY NEW Year everyone!
I tried again the append query function - and it combines now the tables without error. But it is not the solution i wanted as with this append function it retrieves the historic data (1 Million Rows +) and the current data.
Has someone another idea? I don't know why it doesn`t work with the DAX Union Formula.
