Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Aggregation

is there a calculated formula to get minimum value of ON_HAND_QTY without using built-it options of aggregation.

 

 

  • VahidDM's avatar
    VahidDM
    4 years ago

    Anonymous 

     

    It works well with the previous code: 

    Measure = min(Data[ONHAND_QTY])
     

     

    Is there any difference between the file you shared and original file?

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

     

10 Replies

  • Hi Anonymous 

     

    Try this:

    measure = Min([ON_HAND_QTY])

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      hello VahidDM, not sure why it's not showing the correct value. value should be 35 and 13

       

       

      • VahidDM's avatar
        VahidDM
        Super User

        add table name to the measure: measure = Min(table[ON_HAND_QTY])

        Can you share a sample of your data?

         

        Appreciate your Kudos!!

         

  • Anonymous 

    Create a Measure:

    Min_OnHand_Qty = MIN ( TableName[OnHand_Qty])



    • Anonymous's avatar
      Anonymous
      Not applicable

      Fowmy weird it's not working

       

       

      • Fowmy's avatar
        Fowmy
        Super User

        Anonymous 

        Share some sample/dummy data and the expected results.