Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

Modify the measure to apply it for separate Payers in Table1 if = var current =…

  1. User

    Modify the measure to apply it for separate Payers in Table1

    if =

    var _current = MAX(Table1[date])

    var _next = CALCULATE (MAX ('Table1'[date]),

    FILTER (ALL(Table1), 'Table1'[rank] = MAX ('Table1'[rank]) + 1)

    )

    var _datediff =

    DATEDIFF (_current, _next, DAY )

    RETURN

    IF ( _datediff = 1, 0,1 )

  2. Assistant

    if =

    var _current = MAX(Table1[date])

    var _next_payer = CALCULATE (MAX ('Table1'[date]), FILTER (ALL(Table1), 'Table1'[rank] = MAX ('Table1'[rank]) + 1 && 'Table1'[payer] = MAX ('Table1'[payer])) )

    var _datediff =

    DATEDIFF (_current, _next_payer, DAY )

    RETURN

    IF ( _datediff = 1, 0,1 )