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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks ImkeF for your extremely fast & clear reply :)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sorry, i come back to it, not sure to fully understand.

 

Hence, doing Union + Summarize in DAX consumes more place on the hard drive than the Append funtion in Power Query. :(

 

To be sure i understand the logic,

If table "old" has the old data, the one that should still appear on the report but never change, I should set it to

- Enable load: option selected

- Include in report refresh: option not selected

 

For the table "new", where it should be refreshed and loaded, both options are selected.

 

I am right?

BR, G.