Forum Discussion
use relatedtable to pull dates from another table
I am in direct query mode utilizing two tables that have a many to many relationship. The tables are related based on a salesorder key. I am trying to create a relatedtable measure/calculated column...
Hi Anonymous ,
amitchandak is right , so I can give you other solutions
Below is my table1:
Below is my table2:
The following DAX might work for you:
Column = RELATED('Table'[Socreatedate])The final output is shown in the following figure:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserAnonymous , You can use related in case of direct query to bring data from one side to many side . Because you want data from dim, you should be able to use related
I do not think you need a relatedtable a simple measure will aggregate data against many side to one side