gpt-3.5-turbo-0613· OpenAI
WildChat-4.8M (AI2)
Modify the measure to apply it for separate Payers in Table1 if = var current =…
- 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 )
- 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 )