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

Hi Parry

 

sure, but i guess that`s not really helpful. The column structure is the same in both tables. Also it retrieves the correct data from the Server, only after the union formula it writes at the end the KABEG to the Sales_Rev_Quantity.

 

KR

 

Florian

 

parry2k's avatar
parry2k
Super User
9 years ago

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? 

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