Forum Discussion
Max sequence number filtered
Took some time, but I solved it. It was easier to stop into it with two columns
First new column:
Max on Day = CALCULATE(MAX('Vetting Query'[CHILD_SEQ]),ALL('TABLE'),'TABLE'[PARENT_SEQ]=EARLIER('TABLE'[PARENT_SEQ]) && 'TABLE'[CHILD_SEQ_DATE]=EARLIER('TABLE'[CHILD_SEQ_DATE]))
This gave me the max sequence number for the child sequence per day on every row related to that parrent seq.
Second new column:
Number Processed = if('TABLE[Max on Day]='TABLE[CHILD_SEQ],'Vetting Query'[CHILD_SEQ],"")
The Number Processed will only have the Max CHILD_SEQ on the row of the Max sequence number and a blank if its not the max sequence number.
I tried this as well:
This is the error I get:
The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression.
Took some time, but I solved it. It was easier to stop into it with two columns
First new column:
Max on Day = CALCULATE(MAX('Vetting Query'[CHILD_SEQ]),ALL('TABLE'),'TABLE'[PARENT_SEQ]=EARLIER('TABLE'[PARENT_SEQ]) && 'TABLE'[CHILD_SEQ_DATE]=EARLIER('TABLE'[CHILD_SEQ_DATE]))
This gave me the max sequence number for the child sequence per day on every row related to that parrent seq.
Second new column:
Number Processed = if('TABLE[Max on Day]='TABLE[CHILD_SEQ],'Vetting Query'[CHILD_SEQ],"")
The Number Processed will only have the Max CHILD_SEQ on the row of the Max sequence number and a blank if its not the max sequence number.