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:
Go to Solution.
Swap the MAX for EARLIER.
Next time please post the sample data as text (not a picture)
View solution in original post
Fantastic @HotChilli it worked perfectly as you no doubt expected.
(The sample data request has been noted for next time).
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.