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 come back with it's current price, but then in a seperate column bring back what the lowest price found for that item was. Something similar to below. Any help would be great! Thank you!

 

Item Current Price  Lowest Price 
56748 $             0.965 $   0.084
56748 $             0.820 $   0.084
56748 $             0.084 $   0.084
56748 $             0.813 $   0.084
56748 $             0.710 $   0.084
56748 $             0.172 $   0.084
56748 $             0.532 $   0.084
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

3 Replies

  • Avantika-Thakur's avatar
    Avantika-Thakur
    Solution Supplier
    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you, this worked! Would you be able to tell me the measure I should use to calculate the difference between the two? Current price minus the lowest price found. I'm trying with just a quick measure but that forces it to be a sum or a count.

  • SolomonovAnton's avatar
    SolomonovAnton
    Super User
    4 years ago

    hello

     

     

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