Forum Discussion
addcolumns from two dimensions tables
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
What if you create a couple of measures, to represent your facts and write something like:
evaluate(
summarize
(
'mstdates'
,'tag'[tag]
,'area'[area]
,"earned hours", [earned hour]
,"budget hours", [budget hours]
)
)
summarize will work only for 1 table, at least that's my understanding, that's why, i am using addcolumns ?
summarize will work for on base table, but you are able to reference columns in related tables and use measures
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
