Verification of multiple records

[Syndicate_Admin]

Good morning community, please need help with this problem

I have the following data structure.

The objective is to determine if the production order was finalized. In order to identify this variable I have availability of the data "Current Operation Order" and "Last Operation Order" where if Current Operation Order = Last Operation Order it is indicated that the production order was finalized with which all the records of said order must contain a variable of "Completed".

Example order 05/2022 was finalized so each record of that order must have the variable "Completed" and order 016/2022 is "in process" when it meets Order No. 5 (the last order to be considered as completed is 14)

I would appreciate help please

Thanks a lot!!!

[v-rongtiep-msft]

Hi @Syndicate_Admin ,

Please have a try.

Create a column.

column=
if(table([orden operacion actual ]=earlier(table[orden operacion ulitma]),"yes",no)

Then create a measure.

Measure = MAXX(FILTER(ALL('Table'),'Table'[id]=SELECTEDVALUE('Table'[id])),'Table'[Column])

If I have misunderstood your meaning, please provide mode details with your desired output and pbix file without privacy information.

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

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