Add Column with data from other table

[Peter32]

Hello,

I think I have a little problem, but I just can't figure it out, please help me.

Table 1 Sales

Column = Salesemployee

Joe

Jim

Eveline

Sam

Sandra

Table 2 Orders

Columns =   Ordernumber

Orderdate

Orderamount

Discount

Question: I want to work with the columns in the table 2 Orders excluding the orders from Joe and Eveline. 

That's why I want to add a column in table 2 Orders in which the status "include" or "exclude" is stated per order in order to be able to filter with this.

What is the best way to do this, or are there other solutions.

Thanks!

[v-xinruzhu-msft]

Hi @Peter32 

First you need to find the related ordernumber with Joe/Eveline, if you have the ordernumber in Sales table, then you can create a new column in Orders table 

Column =
VAR a =
    SUMMARIZE (
        FILTER ( Sales, [ordernumber] = EARLIER ( Orders[ordernumber] ) ),
        [Salesemployee]
    )
RETURN
    IF ( OR ( "Joe" IN a, "Eveline" IN a ), "include", "exclude" )

Best Regards!

Yolo Zhu

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

[Sahir_Maharaj · Accepted solution]

Hello @Peter32,

Can you please try to add a new calculated column to the "Orders" table:

Status = 
IF (
    Orders[Salesemployee] = "Joe" || Orders[Salesemployee] = "Eveline",
    "exclude",
    "include"
)

 Should you require further assistance please do not hesitate to reach out to me.