So to use a Table Calculation, such as LOOKUP, the measure needs to be an aggregate. As you have your measure [extension (mm)] dis-aggregated, we can wrap it in a MIN (or MAX or AVG for that matter). So the calculated fields become;
I've added these to the ToolTips so you can see how it's working.
First and Last Values.twbx 102.2 KB
Thanks for the formula with lookup()! I didn't know we can use them like
I used to use something more verbose like:
Window_Max(if first()=0 then Max(extension (mm)) end)
Window_Max(if last()=0 then Max(extension (mm)) end)
On Thu, Sep 8, 2016 at 2:46 AM, Simon Runc <firstname.lastname@example.org>