Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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).