Forum Discussion

Greg888's avatar
Greg888
Helper I
4 years ago
Solved

Getting a max step from a group

Hi All   I have what I think could be a fairly simply problem to solve but I have been going around and around in circles to try to get the answer and now I'm just stuck or not understanding why th...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago
    MaxStepNo =
MAXX(
    FILTER(
        'Document Steps',
        'Document Steps'[DocNumber] = EARLIER( 'Document Steps'[DocNumber] )
    ),
    'Document Steps'[StepNo]
)
CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago
MaxStepNo =
MAXX(
    FILTER(
        'Document Steps',
        'Document Steps'[DocNumber] = EARLIER( 'Document Steps'[DocNumber] )
    ),
    'Document Steps'[StepNo]
)
Greg888's avatar
Greg888
Helper I
4 years ago

ok thank you for this so that produced the last step correctly as a number in the column

I then did a 

IF(Document Steps [MaxStep] = DocumentSteps[StepNo],1,0)

Which has given me a column I can use going foward. Thanks for all your help