Calculated Column - Fill Down

[tonybrogan]

Hi Everyone,

I'm struggling creating a calculated column for my dataset but surprisingly I have found a measure (thanks Ruth @ Curbal) but it returns blanks when repeated as a column.

So my data loads as follows (columns A to F) and my goal is to create Column G:

This is my successful measure:

Fill Vendor ID Measure =

MAXX(

FILTER(

ALL('Sample fill data'),

'Sample fill data'[DocumentNo]=MAX('Sample fill data'[DocumentNo])),

'Sample fill data'[Vendor])

Any time and help anyone can offer on this will be greatly appreciated.

Regards

Tony

[HotChilli · Accepted solution]

Swap the MAX for EARLIER.

--

Next time please post the sample data as text (not  a picture)

[tonybrogan]

Fantastic @HotChilli  it worked perfectly as you no doubt expected.

Thank you.

(The sample data request has been noted for next time).