Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Lowest Price

Hello All,   I am trying to get a calculation that will give me the lowest price by item. I have a list of items that can be listed multiple times with all different prices. I want each record to c...
Need Help
  • Avantika-Thakur's avatar
    Avantika-Thakur
    4 years ago

    Hi Anonymous ,

    You can try creating the below measure -
    Lowest price = CALCULATE(MIN(Current Price),ALLEXCEPT(Table,Item))

    Hope this helps!

    Please accept the solution if this answers your query.

    Thanks!

    Avantika

SolomonovAnton's avatar
SolomonovAnton
Icon for Super User rankSuper User
4 years ago

hello

 

 

measure Lowest Price = 
 calculate(min('Table'[Current Price]),filter(all('Table'),'Table'[Item]=min('Table'[Item])))