Help to creat a calculated column in dax

Hi leandross89 ,

Thanks to Ahmedx  for the reply, please allow me to provide another insight:
1. Create a calculated column and populate the data in groups.

Column =
CALCULATE(MIN('Table'[Index]),FILTER(ALL('Table'),'Table'[Rule_rank] = "Rank" && 'Table'[Index] >= EARLIER('Table'[Index])) )

2. Create a calculated column and display OK if it meets the conditions.

Column 2 =
IF('Table'[Index] < 'Table'[Column] && 'Table'[Searched] = 367 && 'Table'[Code] = "A" ,"OK")

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.