Forum Discussion
Add Column with data from other table
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!
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.
2 Replies
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.
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.
