Forum Discussion
MIN based on description column
Hi,
I am trying to generate the 'Min' column as shown in my excel screenshot below by writing a DAX column.
The criteria is that based on 'Mat desc' the 'Min' column will contain the MIN 'Price' that 'Mat desc' has ever been.
I have tried a few formulas but to no avail, can anyone help? Thanks.
To answer my own question here is the solution for those who want it:
Min Col = CALCULATE(MIN(Sheet1[Price]),FILTER(Sheet1,Sheet1[Mat desc]=EARLIER(Sheet1[Mat desc])))
2 Replies
I was using the following link as a guide but couldnt seem to get it working:
https://www.kasperonbi.com/determine-the-min-value-over-rows-in-a-group-using-minx-in-powerpivot/
To answer my own question here is the solution for those who want it:
Min Col = CALCULATE(MIN(Sheet1[Price]),FILTER(Sheet1,Sheet1[Mat desc]=EARLIER(Sheet1[Mat desc])))