Cannot display two connected fields together

[HitcH]

Hi everyone

This is my situation

Table 1 -> sales order, date of order creation

Table 2 -> sales order, date of delivery

Table 3 -> list of sales order

Sales order is connected from 1 to 3 and from 2 to 3.

I created a table with sales order (from table 3) and date of order creation (from table 1) -> ok

I created a table with sales order (from table 3) and date of delivery (from table 2) -> ok

I created a table with sales order (from table 3), date of order creation (from table 1) and date of delivery (from table 2) -> not ok ("cannot determine relationship").

I don't get why shouldn't this work 🤔 any help?

Regards

[Anonymous]

Hi @HitcH ,

According to your description, here are my steps you can follow as a solution.

(1)This is my test data.

(2) We can create measures. 

_date of order creation = LOOKUPVALUE('Table 1'[date of order creation],'Table 1'[sales order],MAX('Table 3'[list of sales order]))

_date of delivery = LOOKUPVALUE('Table 2'[date of delivery],'Table 2'[sales order],MAX('Table 3'[list of sales order]))

(3) Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[HitcH]

Hi

Please see my pbix file, your solution is not working 😞

https://wetransfer.com/downloads/a1a9639c344443dcc0cec1089eee7c2220230703133333/4cb2247fd49644017b34...

[HitcH]

Hi

Thanks for your support.

Actually, your solution is not working for me. I'm unable to attach the file (i get the error message that pbix files are not supported, don't know why: https://community.fabric.microsoft.com/t5/Desktop/The-file-type-pbix-is-not-supported/td-p/3308037).
Anyway, this is the tables that I created as exmaple:

Sales order	Date of creation
1	09/01/1900
2	19/02/1900
3	02/02/1900
4	17/01/1900
5	05/01/1900
6	17/03/1900
7	30/03/1900
8	12/01/1900
9	12/01/1900
9	13/01/1900

Sales order	Date of delivery
5	07/01/1900
6	07/01/1900
7	11/01/1900
8	14/02/1900
9	06/03/1900
10	09/01/1900
11	10/01/1900
11	13/02/1900

Sales order	Not relevant
1	.
2	.
3	.
4	.
5	.
6	.
7	.
8	.
9	.
10	.
11	.

You should be able to easily re-create the pbix file with this, but it is not working with your formulas...

Thanks in advance!

[HitcH]

Just to add some few details that might be helpful:

I'm unable to display Sales docume / OO Day / OE Day all together