Forum Discussion

ap12's avatar
ap12
Frequent Visitor
4 years ago
Solved

Column filter value

Hello,   I'm looking to create a new column that shows only shows the value once if there are multiple rows with the same unique ID and filter.   Here is the sample of the table:   Cli...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    4 years ago

    ap12 , Create a new column

     

    column =

    var _min = minx(filter(Table, [client ID] = earlier([client id])), [Date Invoice])
    return
    if( [Contract Type] = "SUB" , if([Date Invoice] =_min, [Invoice], blank()),[Invoice])

amitchandak's avatar
amitchandak
Super User
4 years ago

ap12 , Create a new column

 

column =

var _min = minx(filter(Table, [client ID] = earlier([client id])), [Date Invoice])
return
if( [Contract Type] = "SUB" , if([Date Invoice] =_min, [Invoice], blank()),[Invoice])

  • ap12's avatar
    ap12
    Frequent Visitor
    4 years ago

    Thanks amitchandak. Your formula worked!!