Forum Discussion

pokarman's avatar
pokarman
Frequent Visitor
6 years ago

How to get min value from calculated based on one column

In the below image there is Minprice calculated measure so i want to extract min value from that measure column based on plant code.

 

this column are coming from multiple tables

11 Replies

  • Jimmy801's avatar
    Jimmy801
    Community Champion

    Hello pokarman 

     

    you need to have this in a visualization or in power query as new calculated column?

     

    Jimmy

      • Jimmy801's avatar
        Jimmy801
        Community Champion

        Hello pokarman 

         

        create a new measure like MinMinPrice = Min(YourTableName[MinPrice])

        Then create table in your visualisation, drag the plant and the new measure into your visualization.

         

        If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
        Kudoes are nice too

        Have fun

        Jimmy

  • Jimmy801's avatar
    Jimmy801
    Community Champion

    Hello pokarman 


    have you been able to solve the problem with the replies given?

    If so, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    All the best

    Jimmy