need help counting and concatenate how many times an id appear in a selected timeframe

[cristianj]

Hello, 

I need to count how many time an id appear in a selected timeframe, i wa thinking of making a new measure 

Nr de comenzi in perioada selectata = calculate(count(ordersSM[buy_order_id]),filter(ordersSM,ordersSM[seller_id]=[seller_id])),

and then i need to concatenate something like buy_order_id from date_of_buy_order_id, next_buy_order_id from next_date_buy_order_id...

If you have any solutions would be great thank you

[v-kkf-msft]

Hi @cristianj ,

Please provide some sample data.

[cristianj]

user_id	id	data(DateTime) (dd/mm/yyyy hh:mm)	New Column(next id of the user_id with datediff<24)
1	1001	01/09/2022 08:00	BLANK
2	1002	01/09.2022 09:00	BLANK
3	1003	01/09/2022 10:00	Blank
4	1004	01/09/2022 11:00	Blank
5	1005	01/09/2022 12:00	Blank
1	1006	01/09/2022 16:00	1001
2	1007	01/09/2022 17:00	1002
1	1008	05/09/2022 08:00	Blank
4	1009	05/09/2022 08:00	Blank