Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

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

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.

Frequent Visitor

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 



Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors