Forum Discussion
Solved
Calculated Column - Fill Down
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
Swap the MAX for EARLIER.
--
Next time please post the sample data as text (not a picture)
2 Replies
Swap the MAX for EARLIER.
--
Next time please post the sample data as text (not a picture)
Fantastic HotChilli it worked perfectly as you no doubt expected.
Thank you.
(The sample data request has been noted for next time).
