Power BI index column with multi condition

[vitalijusb_sisp]

Hi,

I can't find the solution to calculate index column (NEW INDEX) by example (below).

Index start from 1 when changes Date or Parking or Direction.

I tried this DAX:

NEW INDEX = VAR _Date = Table[Date]

VAR _Direction = Table[Direction]

VAR _Parking = Table[Parking]

RETURN

CALCULATE(COUNT(Table[Date]); FILTER(Table; Table[Date] = _Date && Table[Direction] = _Direction && Table[Parking] = _Parking))

Could you can help?

Id	Direction	Date	Time	Parking	NEW_INDEX
3248	In	2018-01-02	07:15:05	A	1
3249	In	2018-01-02	07:56:24	A	2
3250	In	2018-01-02	08:06:06	A	3
3251	In	2018-01-02	08:21:19	A	4
3258	Out	2018-01-02	17:14:04	A	1
3260	Out	2018-01-02	17:17:44	A	2
3261	Out	2018-01-02	17:58:46	A	3
3263	Out	2018-01-02	19:59:54	A	4
1766	In	2018-01-02	07:12:19	B	1
1767	In	2018-01-02	11:33:17	B	2
1768	Out	2018-01-02	14:56:59	B	1
1769	Out	2018-01-02	17:27:29	B	2
3269	In	2018-01-03	07:14:02	A	1
3270	In	2018-01-03	07:20:03	A	2
3271	In	2018-01-03	07:39:35	A	3
3277	Out	2018-01-03	10:50:45	A	1
3278	Out	2018-01-03	11:11:17	A	2
3281	Out	2018-01-03	17:03:16	A	3
3287	Out	2018-01-03	20:00:18	A	4
5153	In	2018-01-03	18:14:46	C	1
5154	In	2018-01-03	18:28:44	C	2
5155	In	2018-01-03	18:30:11	C	3
5184	Out	2018-01-03	20:28:30	C	1
5185	Out	2018-01-03	21:08:00	C	2
5186	Out	2018-01-03	21:08:13	C	3

Thanks

Vitalijus

[Anonymous · Accepted solution]

[New Index] =
var __date = T[Date]
var __direction = T[Direction]
var __parking = T[Parking]
var __time = T[Time]
var __index =
	COUNTROWS(
		FILTER(
			T,
			TRUE()
			&& T[Date] = __date
			&& T[Direction] = __direction
			&& T[Parking] = __parking
			&& T[Time] <= __time
		)
	)
return
	__index

Best

Darek

[vitalijusb_sisp]

Thank you very much ! That's great !