Forum Discussion
Advocate Vaddcolumns 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
Hi,
Could you post a schema or describe how the relationships look for your tables: tag, mstdates and area?
Since Addcolumns will evaluate all expressions on each row for your "base" table, and the expression must evaluate to a scalar value the relationship from table tag to the table area should be many to one.
Does this make sense?
Br,
Magnus
Advocate VI have two fact tables
fact table 1(tag, area, earned hours)
fact table 2(tag, area, budget hours)
the tags and area are not always the same in the two tables
two Master tables
tag(tag) (PK)
area(area)(PK)
i am looking to have this result
tag,area, sum(earned hours), sum(budget hours)
msdate is just a dummy table for storing measures.