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:
Solved! Go to Solution.
Swap the MAX for EARLIER.
--
Next time please post the sample data as text (not a picture)
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).