DAX help - create column with minimum value so far inside a group

Question

Hello all,&nbsp;I am looking for some help to create a calculated column which holds the minimum value recorded in a group.&nbsp;&nbsp;I have an Index, Group, and Value column.&nbsp; The Lowest column should be the minimum value recorded in that group up to the index.&nbsp;I thought this would be easy by filtering the Index to calculate the minumum value (MINX) between Index between Group and current Index but I just get zero.&nbsp; I think it's finding the minumum value in the whole range insteas of evaluating row by row.&nbsp;Here is some data to explain hwo the lowest should work:&nbsp;IndexGroupValueLowest232366242333252383262393272722282742292732302700312710323266333255343233353243363273373293383211&nbsp;Thanks for any ideas and help!

jihwan_kim · Accepted Answer

Hi,&nbsp;stalerik&nbsp;&nbsp;Please try the below.&nbsp;&nbsp;Lowest CC =VAR currentgroup = 'Table'[Group]RETURNCALCULATE (MIN ( 'Table'[Value] ),FILTER ('Table','Table'[Group] = currentgroup&amp;&amp; 'Table'[Index] &lt;= EARLIER ( 'Table'[Index] )))&nbsp;&nbsp;Hi, My name is Jihwan Kim. &nbsp;If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up. &nbsp;Linkedin: linkedin.com/in/jihwankim1975/Twitter: twitter.com/Jihwan_JHKIM

Forum Discussion

DAX help - create column with minimum value so far inside a group

2 Replies

Related content

Create columns group

Creating a custom column

Creating a date column

Create measure to return value from column when condition met for two other columns

unpivoting columns and creating datetime column

Index	Group	Value	Lowest
23	23	6	6
24	23	3	3
25	23	8	3
26	23	9	3
27	27	2	2
28	27	4	2
29	27	3	2
30	27	0	0
31	27	1	0
32	32	6	6
33	32	5	5
34	32	3	3
35	32	4	3
36	32	7	3
37	32	9	3
38	32	1	1