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

mim's avatar
mim
Advocate V
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
4 years ago

UPDATE: 

Ok, problem solved. It seems that problem was not in DAX, but in AAS beause changes weren't correctly pushed to data model. After updating Data MOdel correctly, everything works fine. 


Dear  Advocate V, 

 

I used your solution in my data model stored in Analysis Services and it worked for some time, but now returned table is mixed again and I haven't changed anything in source tables. 

Funny thing is that it works fine in  Analysis Services, but table is mixed in PowerBi. 

Do you have any idea what could be  problem?

 

Regards, 

Tomasz