related tables

[FCF]

hi

i have two tables, and have created a relationship between them. 

the trouble is that i can only see a limited # of the columns in one of the tables. in most cases i can pull information from both.

but some columns do not show up when trying to use them in a formula?

thanks

[pranit828]

Hi @FCF 

If the column names are not shouwing in the formula. Mostly happens in case of measures.

Use SELECTEDVALUE(table[Column]) instead. This will atlest help you to get to see the formula.

[amitchandak]

@FCF , there can be some missing values. Try with option and check.

Put key from both tables and check.

when you put keys from two tables, then if there is anything missing on 1 side, you will see null and value on M side .

With this option, you will see missing on M side

[FCF]

this is the column that i want added to the targets table to calulate the difference between  the budget and  actual values

[Fowmy]

@FCF 

If you are creating a measure formula then you must start with some function like SUM, AVERAGE,etc to see the column name coming up. 

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn 

[FCF]

hi

thanks for the response, but i am unsure of what you are asking me to do?

in this example i am in the Target tabel and able to pull  information from the Bayview Table

but if i try to get the column that is margin $ (CDN) from the target table it does not show up, and using related does not seem to help

very frustrating. thanks