create a conditional flag

[jfmejiav1]

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 

[AlB · Accepted solution]

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 )