Forum Discussion
Union Formula mixes columns
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))
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))
Very good point mim!
I've included your very valuable tip into my blogpost, describing this solution a bit in detail :-)
You'll also find a downloadable file there to test this approach: http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
Hi
Thanks for your hint with Union + Summarize
But now i have the impression that the size of my PBIX files is doubling. Can it be?
I am doing so:
Table a 5 Mb
Table b 6 Mb
Table resulting of Union + Summarize = 11 Mb
#1 Can that be?
I am quite confused here. I thought that what happens with DAX stays in the memory only. #2 Is that the case or not??
Best regards. G.