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

ImkeF's avatar
ImkeF
Community Champion
7 years ago

Yes, that's to be expected.

Filesize doubles, as data doubles. The data will be stored in the file (on the disk, when closed) ane just loaded to RAM once opened and you work with it.

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.