Forum Discussion
Help Required - Flag to identify Earliest Occurrence for given 'Status'
Hi Everyone - am looking for a DAX to resolve following;
| Item No. | Status | Date_Time | Flag |
| 109384012 | Active | 2/9/2020 : 9:20:10 AM | Y |
| 109384012 | Pending | 22/9/2020 ; 10:45:23 AM | N |
| 109384012 | Active | 10/10/20 : 20:10:18 | N |
| 10928349 | Closed | 24/07/20 : 16:36:48 | N |
| 10928349 | Pending | 31/07/20 : 23:10:15 | N |
i want to calculate 'Flag' with following condition;
- When 'Status' is 'Active', AND;
- Date_Time is 'Earliest' instance
Please if you can help resolve this?
Anonymous ,
As a new column
if([Date_Time] = min([Date_Time]) && [Status] = "Active", "Y", "N")
a new column item wise
if([Date_Time] = minx(filter(Table,[Item No]= earlier([Item No])).[Date_Time]) && [Status] = "Active", "Y", "N")
2 Replies
- amitchandak
Super User
Anonymous ,
As a new column
if([Date_Time] = min([Date_Time]) && [Status] = "Active", "Y", "N")
a new column item wise
if([Date_Time] = minx(filter(Table,[Item No]= earlier([Item No])).[Date_Time]) && [Status] = "Active", "Y", "N")
- Ashish_Mathur
Hi,
This calculated formula works
=if(and(CALCULATE(MIN(Data[Date_Time]),FILTER(Data,Data[Item No.]=EARLIER(Data[Item No.])&&Data[Status]="Active"))=Data[Date_Time],Data[Status]="Active"),"Y","N")Hope this helps.
