Create Data Flag using If condition

Hi Anonymous 

Do you have all three column customer_key interection_id interaction_date the same values? Assume no...here is one way in M, paste in Advanced Editor of Power Query Editor

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("rdE7bgMxDATQu2xtYimK39LZ2JcwXEha6v5HyMZwGQcxkH7wMEPebgsiFqy1ytWIY1M8c8hWr8tpkUZcTBAi2YFNERyFIb1zUKZxwyNGvmK**bleep**L/fQr2NmrjiJQxRB4kkPrKJAD2cin7q4/gpsdhFw+/UPMHuDl/J2sWppqD+jSFXjsfnQtCKglUWMmvmj4Egxv0ccEekyOnSAkFKy0kbNzdeG3QE0eki4wmxpwEwOvxUGCqWTdp01664Z/fUr8N+hrwSd4/wI=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [customer_key = _t, interection_id = _t, interaction_date = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"customer_key", type text}, {"interection_id", type text}, {"interaction_date", type date}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"customer_key"}, {{"allrows", each _, type table }}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each [a=Table.AddIndexColumn([allrows],"Index",0,1),
b=Table.AddColumn(a,"Repeated", each 
 if [Index]=0 then 0
 else if [interaction_date]=a{[Index]-1}[interaction_date] then 1 
 else if [interaction_date]-a{[Index]-1}[interaction_date]< #duration(7,0,0,0) then 2
 else 3 )][b]),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Removed Other Columns", "Custom", {"customer_key", "interection_id", "interaction_date", "Repeated"}, {"customer_key", "interection_id", "interaction_date", "Repeated"})
in
    #"Expanded Custom"

Hi Anonymous 

You can try the following steps,

Step 1,create a column index base on base-table:

Step 2,create column   to sort customer_key by groups,

Column 2 =

RANKX(FILTER('Table','Table'[customer_key]=EARLIER('Table'[customer_key])),'Table'[Index],,ASC,Dense),then you will get the below:

Step 3,use the following measure:

repeat =

VAR test1 =

    CALCULATE (

        COUNT ( 'Table'[customer_key] ),

        FILTER (

            ALL ( 'Table' ),

            'Table'[customer_key] = MAX ( 'Table'[customer_key] )

        )

    )

VAR test2 =

    CALCULATE (

        DISTINCTCOUNT ( 'Table'[interection_id] ),

        FILTER (

            ALL ( 'Table' ),

            'Table'[customer_key] = MAX ( 'Table'[customer_key] )

        )

    )

VAR test3 =

    CALCULATE (

        DISTINCTCOUNT ( 'Table'[interaction_date] ),

        FILTER (

            ALL ( 'Table' ),

            'Table'[customer_key] = MAX ( 'Table'[customer_key] )

        )

    )

VAR TEST4 =

    CALCULATE (

        DATEDIFF (

            MIN ( 'Table'[interaction_date] ),

            MAX ( 'Table'[interaction_date] ),

            DAY

        ),

        FILTER (

            ALL ( 'Table' ),

            'Table'[customer_key] = MAX ( 'Table'[customer_key] )

        )

    )

VAR a2 =

    MAX ( 'Table'[Column 2] )

VAR A1 =

    IF (

        a2 = 1,

        0,

        IF (

            test1 > 1

                && TEST3 = 1

                && TEST2 > 1,

            1,

            IF (

                TEST1 > 1

                    && TEST2 > 1

                    && TEST4 >= 2

                    && TEST4 < 7,

                2,

                IF ( TEST1 > 1 && TEST2 > 1 && TEST4 = 7, 3, BLANK () )

            )

        )

    )

RETURN

    A1

Final you will get what you want!

Wish it is helpful for you !

Click here to download pbix file if you need!

Best Regard

Lucien Wang