Forum Discussion

Flori_Abb's avatar
Flori_Abb
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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?