How to select a sub-set of rows to do a min()

Nicolai — Fri, 09 Sep 2016 08:00:04 GMT

Hi,
I have somewhat of a challenge I can't quite figure out.
I have an SQL table full of production data information and some OK counters.
The OK counters are not normalized, meaning they carry on the counter from the previous order.
I would like to add a column to my dataset, where I normalize this data.
How I imagined I would do it, was simply to subtract the MIN value, for that production line.
Unfortunately I can't figure out how to select a subset of the rows, based on the production line's Id.
If I just do a min(), I will select across multiple production-lines, meaning the min will only be valid for one of them.

So my table is basically:

ProductionLineId, OrderNo, Timestamp, OkCounter

Where I'd like to add a NormalizedOk.

How should I go ahead with achieving this?

I hope it is clear what I'm trying to achieve. Please ask any questions that come up.

Re: How to select a sub-set of rows to do a min()

quratzafar — Mon, 19 Sep 2016 04:37:26 GMT

This is how I would try to solve the problem,

Min/Production ID = Summarize(<YourTableName>, ProductionID, min (OK number))

This will generate a table that conatins the minimum for each production id. Then you can join this table with the original and create a new calculated column where you subtract i.e

Normalized number = ok number - min number

Let me know if this helps

topic How to select a sub-set of rows to do a min() in DAX Commands and Tips

How to select a sub-set of rows to do a min()

Re: How to select a sub-set of rows to do a min()