Forum Discussion
DAX : Count rows before specific row
Hello, I'm struggling with a DAX (or logic) calculation, I have a 'Qualification' parcel Table which contains these columns : - Event_Biztranslist : ID of parcel - Event_Type : Type of event ...
Try this,
Column = VAR Parcel = 'Table'[Event_Biztransit] VAR EventReader = Calculate( MAX( 'Table'[Event_Time] ) , ALL('Table') , 'Table'[Event_Biztransit] = Parcel , Table'[Event_Type] = "ObjectEvent" , Table'[Readpoint_Type] = "Reader") Return IF('Table'[Event_Time]<EventReader , 1 , 0 )
Is there only 1 row that has the combination of ObjectEvent & Reader?
/ J
Hello,
For each parcel yes there is only one combinaison ObjectEvent & Reader
The screen shows the case for only one parcel