Forum Discussion

jfmejiav1's avatar
jfmejiav1
Frequent Visitor
7 years ago
Solved

create a conditional flag

Hello,

 

Currently y have a table with snapshot of deals the date of the snapshot and if in that date the deal had a flag or not. ( see below)

 

 

I want to create a column that puts the first date when the deal had a flag. So for example deal h first had the flag on the 22, then i only want a date on a new column for the 22th of April not for the 22 and 29.

 

how can i do this?

 

thank you 

Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi jfmejiav1,

    Try this for your new calculated column, where Table1 is the table you show:

    NewCol =
CALCULATE (
    MIN ( Table1[SnapDate] ),
    Table1[Flag] = 1,
    ALLEXCEPT ( Table1, Table1[Deal iD] )
)

    or this (I'm not quite sure which one you need):

    NewCol =
VAR _Date =
    CALCULATE (
        MIN ( Table1[SnapDate] ),
        Table1[Flag] = 1,
        ALLEXCEPT ( Table1, Table1[Deal iD] )
    )
RETURN
    IF ( Table1[SnapDate] = _Date, _Date )

     

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi jfmejiav1,

    Try this for your new calculated column, where Table1 is the table you show:

    NewCol =
CALCULATE (
    MIN ( Table1[SnapDate] ),
    Table1[Flag] = 1,
    ALLEXCEPT ( Table1, Table1[Deal iD] )
)

    or this (I'm not quite sure which one you need):

    NewCol =
VAR _Date =
    CALCULATE (
        MIN ( Table1[SnapDate] ),
        Table1[Flag] = 1,
        ALLEXCEPT ( Table1, Table1[Deal iD] )
    )
RETURN
    IF ( Table1[SnapDate] = _Date, _Date )