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 that returns the SOcreateddate from the dimorderinvoicemapping table and places those dates on the factsalesinvoice table
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.
2 Replies
- amitchandak
Super User
Anonymous , 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
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.
