Forum Discussion

Homaa's avatar
Homaa
Frequent Visitor
4 years ago
Solved

How to create a field using another field from another table?

I have several tables from Saleforce database and I want to create a field in one of these tables using a field from another table. To do this, I created the relationship between these two tables in ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Homaa 

     

    You can try the following methods.

    Sample data:

    1. Add a calculated column to the Account table.

    Column:

    Event value =
CALCULATE (
    MAX ( Event[Value] ),
    FILTER ( Event, [AccountID] = EARLIER ( Account[ID] ) )
)

    Result:

    2. On this basis, the SWITCH function is used.

    Column = SWITCH(TRUE(),
[Event value]>50,"A",
[Event value]>20,"B",
"C")

    Result:

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, Homaa 

 

You can try the following methods.

Sample data:

1. Add a calculated column to the Account table.

Column:

Event value =
CALCULATE (
    MAX ( Event[Value] ),
    FILTER ( Event, [AccountID] = EARLIER ( Account[ID] ) )
)

Result:

2. On this basis, the SWITCH function is used.

Column = SWITCH(TRUE(),
[Event value]>50,"A",
[Event value]>20,"B",
"C")

Result:

 

Best Regards,

Community Support Team _Charlotte

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