cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
koorosh
Helper IV
Helper IV

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?

 
 

Capture1.JPGCapture2.JPG

1 ACCEPTED SOLUTION
VahidDM
Memorable Member
Memorable Member

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

 

 

View solution in original post

3 REPLIES 3
VahidDM
Memorable Member
Memorable Member

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

 

 

View solution in original post

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

Eradat

Koorosh@parsehtech.com

Sales_Table.JPGLocation_Table.JPG

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!