Forum Discussion

Flori_Abb's avatar
Flori_Abb
Helper I
9 years ago
Solved

Union Formula mixes columns

Hello together   to improve the download speed from our datawarehouse, i want to split up the data in a historic table (Data from 2013 up to 27th of December) and a current data load table (data fr...
Need Help
  • mim's avatar
    mim
    9 years ago

    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))

Flori_Abb's avatar
Flori_Abb
Helper I
9 years ago

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...

parry2k's avatar
parry2k
Super User
9 years ago

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

 

    • Flori_Abb's avatar
      Flori_Abb
      Helper I
      9 years ago

      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...


      • parry2k's avatar
        parry2k
        Super User
        9 years ago

        Sure, interested to see how this get resolved? Will be good for other users as well.