Forum Discussion

Peter32's avatar
Peter32
Frequent Visitor
3 years ago
Solved

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 =   Ordernu...
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.