Forum Discussion
jlarques
Helper V
Helper VRecover a field from facttable in another facttable
Dear community, I'm working on two fact tables and I want to recover one field from the table one into the table two. Due that I have many relationships from both tables to dimension tables, the re...
danextian
Super User
Super UserWhat do you mean by value by value? You mean the two rows from table1? Please note that calculated columns cannot return more than than a single row. The result must be aggregated one way or another which is essentially what SUMX is doing your formula.
jlarquesHelper V
Helper VYes, I want to recover 77,84€ and 12,97€ from table 1 to table2 in each row, because I have two rows in table 1 and same rows in table 2.
I think the problem is there is no difference betweem both rows to choose one of them.