Forum Discussion
Finding identifier whose given value is smallest
Hello I need your help for a simple issue I cannot solve... I have a table, named TBL below, that contains columns PR, FA and Prio. I need to create a new column RPR with content equivalent to Expec...
You can use
Calc PR = VAR MinPriority = CALCULATE( MIN( 'Query1'[Prio]), ALLEXCEPT(Query1, Query1[FA]) ) VAR Result = CALCULATE( MIN( 'Query1'[PR]), ALLEXCEPT(Query1, Query1[FA]), 'Query1'[Prio] = MinPriority) RETURN Result
Thanks a lot johnt75, you made my day 😊