use relatedtable to pull dates from another table

[dwhittaker1]

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

[Anonymous · Accepted solution]

Hi @dwhittaker1 ,

@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]

@dwhittaker1 , 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