I'm not sure the level of detail calculation is needed. If you are going to filter to Shop B, why not just use MIN(IF Revenue > 0 THEN Date END)? Or am I missing something?
Yeah I sometimes over-complicate things That's right, no level of detail needed!
Many thanks for your replies! I was actually not planning to filter by shop B. Is there a solution you can think of that doesn't involve this?
2 of 2 people found this helpful
You could add that as part of the condition
MIN(IF Revenue > 0 AND Type == 'Shop B' THEN Date END)
Any reason not to filter? The calculation will lock it to Shop B and will be a little less efficient (because all data will be returned and evaluated instead of filtering to only Shop B). Providing a filter would give you flexibility to dynamically change the Shop as desired.
Pooja Gandhi, I have the same over-complicating tendencies