Forum Discussion

elflakoconk's avatar
elflakoconk
Icon for Helper II rankHelper II
6 years ago

Error using RELATED

Hello everyone, I have searched all over the forum and I have not found an answer that will solve me. I'm working with Direct Query, I have 2 tables: The link field is Phone and as you...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

elflakoconk , Related you can use in 1- M relation on M side.

 

you can also move data like this from on table to another

City Name = maxx(FILTER(geography,geography[City Id]=Sales[City Id]),geography[City]) // New column in sales table in my case

 

Minx/maxx/sumx depend on need

elflakoconk's avatar
elflakoconk
Icon for Helper II rankHelper II
6 years ago

Thanks a lot, i'll try this! and will give my feedback