Forum Discussion
mim
Advocate V
Advocate Vaddcolumns from two dimensions tables
i Have two fact tables joined to two dimensions tables, i am trying a dax query to return a calculated table, this dax works for one column, but i don't how to extended to the second column EVALU...
Hi mim,
Is it possible for you to merge the two fact tables together into one table first in Query Editor? Then you should be able to use ADDCOLUMNS or SUMMARIZE Function (DAX) to get the result you need in this scenario.:smileyhappy:
Reference:
POWER BI DESKTOP : MERGE QUERY OPTIONS
Best Practices Using SUMMARIZE and ADDCOLUMNS
Regards
mimAdvocate V
Advocate Vsummarize will work only for 1 table, at least that's my understanding, that's why, i am using addcolumns ?
richbenmintz
Resident Rockstar
Resident Rockstarsummarize will work for on base table, but you are able to reference columns in related tables and use measures