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))
Let me ask it again. You have two queries in PowerBI from same sql server but filtered on different date and then you are using append query in PowerBI Model, is this correct understanding?
I have two queries
one retrieves the historic data Data_AVDWhistoric and
the other retrieves the current data Data_AVDWcurrent
The queries are excactly the same, only the sql retrieval date is different.
Now i used the formula Data_AVDW = union (data_avdwhistoric;data_avdwcurrent) to get a combined table. That should help me to avoid the long loading time of the historic Datatable.
I thought that would be an easy excercise...
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...