Add column

[koorosh]

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?

[VahidDM · Accepted solution]

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✌️!!

[koorosh]

Hi Vahid Khan, The Related works correctly. Thanks for your attention.

Eradat

Koorosh@parsehtech.com

[koorosh]