Status change count and inidicator

[hitesh1607]

Hi - I have a table like below:

Invoice id	Snapshot Date	Status
Abc12	May 1	Closed
Abc12	April 1	Active

I need

1) to get a column that helps me indicate which status is changed by invoiced Id and Snapshot date

2) Count of total status change

Thank you

Hitesh

[amitchandak · Accepted solution]

@hitesh1607 , You can add a new column like

new column =
var _max = maxx(filter(Table, [Invoice id] =earlier([Invoice id]) && [Snapshot Date] <earlier([Snapshot Date])),[Snapshot Date])
return
if([Status] <> maxx(filter(Table, [Invoice id] =earlier([Invoice id]) && [Snapshot Date] = _max),[Snapshot Date]) ,1,0)

and then use that as filter