Forum Discussion

grifdoogindoggy's avatar
grifdoogindoggy
Frequent Visitor
4 years ago
Solved

Match value in same table

Hello, I am trying to create a column that expresses whether something is a discount or not based on criteria within a table. Below is the data set: BookingID ExtraItemQty ExtraItemExtendedCos...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    grifdoogindoggy ,

    New column =
    var _cnt = countx(filter(Table, Table[BookingID] = earlier([BookingID]) && [ExtraItemExtendedCost] <0), [BookingID] )
    return
    If(isblank(_cnt) , "Full Price", "Discount")

amitchandak's avatar
amitchandak
Super User
4 years ago

grifdoogindoggy ,

New column =
var _cnt = countx(filter(Table, Table[BookingID] = earlier([BookingID]) && [ExtraItemExtendedCost] <0), [BookingID] )
return
If(isblank(_cnt) , "Full Price", "Discount")