Forum Discussion
Solved
Summarize after union table
I have an Union new Table.
Bit after this i would to summarize the union result again
UNION(
SUMMARIZE(TABLE1
TABLE1[Key],TABLE1[EKORG],TABLE1[LIFNR],TABLE1[Jahr],
"SUM_R_NETW",sum(TABLE1[SUM_R_NETW]),
"SUM_B_NETW",sum(TABLE1[SUM B_NETW])
)
,
SUMMARIZE(TABLE2,
TABLE2[Key],TABLE2[EKORG],TABLE2[LIFNR],TABLE2[INV Year],
"SUM_R_NETW",sum(TABLE2[SUM_R_NETW]),
"SUM_B_NETW",0
But found no solution
)
Davidmei , In this case group by can be better solution
https://medium.com/@amitchandak/power-bi-power-query-vs-dax-append-and-summarize-data-233f173d0839
1 Reply
Davidmei , In this case group by can be better solution
https://medium.com/@amitchandak/power-bi-power-query-vs-dax-append-and-summarize-data-233f173d0839