Forum Discussion
Add column
Hello, Sales and locations tables have relation as you see. But why when I add the District column to Sales table through Related command I get the following?
Hi koorosh jan
Can you add samples of your tables here?
You can use LOOKUPVALUE code rather than RELATED to create a District column, see the below link:
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
3 Replies
Hi koorosh jan
Can you add samples of your tables here?
You can use LOOKUPVALUE code rather than RELATED to create a District column, see the below link:
https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
