Conditional Statement between two related tables

[MaWrob]

Hello,

I am attempting to write a statement between two related tables.

Table 1:

- Order ID

- Order Status

Table 2:

- ORder ID

- ORder Value

I want to get a column which would say:

: IF table 1 Order status in (cancel, returned) AND Table 2 ORder Value = 0 then 1 else 0

How can I write this? Joining these tables in Power Query is not an option. Tables are big and there are lots of other columns in each

[Uzi2019 · Accepted solution]

Hi @MaWrob 
Create calculated column as below

Status= 

IF( AND(Table1[OrderStatus] in {"cancel", "returned"} , Table2[Order Values]=0), 1,0)

I hope This might solved your issue!

Note : I hope you have connected 2 tables properly.

[TomMartens]

Hey @MaWrob ,

you did not describe how both tables are related (granularity and filter direction) and where you want the calculated column.

Consider creating a pbix file containing sample data that still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix file to OneDrive, Google Drive, or dropbox and share the link. Do not forget describe the expected result based on your sample data.

Regards,

Tom