Forum Discussion
Solved
Looking for a DAX Function to bring data from another table
Dear DAX Experts! I am new to Power BI DAX and I would need your help! I need to find a way to bring data stored in table "DIM 2" to the table "FACT 1". Both tables are not directly linked. ...
Calc Column DIM2 = CALCULATE ( SELECTEDVALUE ( DIM2[Col1] ), CROSSFILTER ( FACT1[SK_COMMONDIM], COMMON_DIM[SK_COMMONDIM], BOTH ), CROSSFILTER ( FACT2[SK_DIM2], DIM2[SK_DIM2], BOTH ) )However, this is not conclusive as one row is not sufficient to verify the data structure of a table.
Hi tamerj1
I have created a quick power bi example, so the expected result is to have the Col1 from DIM2 as a calculated column in FACT1.
The file can be accessed here : https://drive.google.com/file/d/1eHck0Z4W9tpIeak4-AmHQh8qUuNExp7W/view?usp=share_link
In advance, thanks a lot for your time!
tamerj1
Community Champion
Community ChampionCalc Column DIM2 =
CALCULATE (
SELECTEDVALUE ( DIM2[Col1] ),
CROSSFILTER ( FACT1[SK_COMMONDIM], COMMON_DIM[SK_COMMONDIM], BOTH ),
CROSSFILTER ( FACT2[SK_DIM2], DIM2[SK_DIM2], BOTH )
)However, this is not conclusive as one row is not sufficient to verify the data structure of a table.