Forum Discussion
jlarques
Helper V
1 year agoRecover 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
1 year agoWhich specific column are you trying to get value from? Also, please take note that a DAX calc column cannot return more than one row so the result must be aggreated by concatenation, min, max, etc. So if your filter criteria returns more than one possible row, you must decide which of the resulting rows to pick.
jlarques
Helper V
1 year agoHi Danextian,,
apologies but I was flying and I didn't have my laptop.
Let me some time tomorrow morning to share the data with you.