Forum Discussion

bjurek

Helper I

3 years ago

Calculate in row

Hello! Anybody knows how calculate "How many times in a row there is no availability counted from the last date"

amitchandak

Super User

3 years ago

bjurek , if you need a new column

if([Date] = maxx(filter(Table, [Shop] = earlier([Shop])), [Date]) , Countx(filter(Table, [Shop] = earlier([Shop]) && [availability] =0 ), [Date]) , blank())

for measures

if(MAx([Date]) = maxx(filter(allselected(Table), [Shop] = max([Shop])), [Date]) , Countx(filter(allselected(Table), [Shop] = Max([Shop]) && [availability] =0 ), [Date]) , blank())