Forum Discussion

rod_puente's avatar
rod_puente
Helper I
1 year ago
Solved

Min / Max Price

Dear All.   Pls your help. I need to calculate the minimum and maximum prices of a painting, here is the following example:       Regards Rodrigo P.
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi rod_puente ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you Ashish_Excel Nasif_Azam ajaybabuinturi for the prompt response.

    I have created pbix file by using sample data, please go through attached pbix for your reference.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

    Thank you.

ajaybabuinturi's avatar
ajaybabuinturi
Super User
1 year ago

Hi rod_puente,

You can use below measures to achive your requirement. Let me know if you have any questions.

Min Price = CALCULATE(MIN('Sales'[Precio Unitario]), ALLEXCEPT(Sales,Sales[Cod Producto]))
Max Price = CALCULATE(MAX('Sales'[Precio Unitario]), ALLEXCEPT(Sales,Sales[Cod Producto]))

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.