Filterable first date creation

[Max75]

Hello everyone,

I need to create a dimension in a graph, which identifies me the first date when the order goes into 'PAI' status.
I am using :
Date(Min({< [order_status_log] ={'PAI'}>} ([event_date_log]),[Order number]),'DD/MM/YYYY')
Which returns me an unfilterable measure. How do I create a filterable dimension in a graph?
Thank you

Order number	event_date_log	order_status_log
7001022512	29/12/2021 16:47	DRAFT
7001022512	09/02/2022 15:30	IPF
7001022512	01/07/2022 07:49	TBF
7001022512	01/07/2022 11:52	TBF
7001022512	01/07/2022 17:30	TBF
7001022512	01/07/2022 17:30	TBF
7001022512	01/07/2022 17:30	TBF
7001022512	01/07/2022 17:31	PAI
7001022512	04/07/2022 13:17	PAI
7001022512	04/07/2022 13:17	PAI
7001022512	12/07/2022 10:20	PAI
7001022512	12/07/2022 10:20	PAI
7001022512	12/07/2022 10:20	PAI
7001022512	12/07/2022 10:20	PAI
7001022512	12/07/2022 10:20	PAI
7001022512	12/07/2022 10:21	ACT

[chaorenzhu]

Why not just creating a field for the first date in load script, something like:

load [Order number],
date(min(event_date_log)) as first_date
resident [your_table]
where order_status_log = 'PAI'
group by [Order number];

If you want first timestamp instead, just change date() to timestamp()

[Max75]

Unfortunately, I do not have access to the loading script