Forum Discussion
Looking for a DAX Function to bring data from another table
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 , Sorry, not sure I underestand the question.
I am trying to create a calculated column in table FACT1, containing a column in DIM2. The calculated column has to be stored in FACT1. The question is whether there is a "smart" function in Power BI that allows this, such as RELATED (which is not working for this scenario).
Community Championjoreghi
Can you please provide an example? A simple sample data along with the expected result and the logic behind it.
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_linkIn advance, thanks a lot for your time!
- tamerj1
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_linkIn advance, thanks a lot for your time!