Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!!
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.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |