Forum Discussion

Kurt4597's avatar
Kurt4597
Helper I
3 years ago
Solved

Conditional Column based on link between 2 other tables

Hello PowerBI Community, I am stuck on a problem and would be very greatful if somebody could assist me.   Table 1 - Customer List     Table 2 - Order   Table 3 - Fruit Prices ...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    You can create a column like

    Meets condition = 
var filteredOrders = FILTER( 
    RELATEDTABLE(Orders),
    Orders[Fruit] = "Apple" || RELATED('Fruit Prices'[Price]) > 2
)
return NOT ISEMPTY( filteredOrders )
johnt75's avatar
johnt75
Super User
3 years ago

You can create a column like

Meets condition = 
var filteredOrders = FILTER( 
    RELATEDTABLE(Orders),
    Orders[Fruit] = "Apple" || RELATED('Fruit Prices'[Price]) > 2
)
return NOT ISEMPTY( filteredOrders )