Forum Discussion
Solved
Detect smallest number in ID
Hello dear Power BI-Community Following problem to solve: I would like to have a calculated column, which detects the smallest number within an ID. Lets assume this table: ID Number c...
pls try this
calculated column = VAR _t1 = 'Table'[D] VAR _Result = MINX(FILTER('Table','Table'[D]=_t1),'Table'[Number]) RETURN IF('Table'[Number]=_Result,"smallest")
pls try this
calculated column =
VAR _t1 = 'Table'[D]
VAR _Result = MINX(FILTER('Table','Table'[D]=_t1),'Table'[Number])
RETURN
IF('Table'[Number]=_Result,"smallest")
Thank you so much.
Works as expected 🙂