Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Use ID to filter multiple columns

Hello,   I'm looking to create the realized column shown in the table below. It works off the following pseudo-code:   If "Trade Type" = "New Trade" and there is no "Full Unwind" for this ID and...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 

    Please create a calculated column as per below code

    Column = 
VAR tt = CALCULATE(CONCATENATEX(Test,Test[Trade type]," "),ALLEXCEPT(Test,Test[ID]))
RETURN IF(AND(tt="New Trade",Test[Expirey Date]>=Test[Today]),"N","Y")
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 

Please create a calculated column as per below code

Column = 
VAR tt = CALCULATE(CONCATENATEX(Test,Test[Trade type]," "),ALLEXCEPT(Test,Test[ID]))
RETURN IF(AND(tt="New Trade",Test[Expirey Date]>=Test[Today]),"N","Y")
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Anonymous 

Many thanks for your contribution! The answer is correct however this will only work on import and not direct query for those who read and also wish to follow this technique.