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.    
Need Help
  • 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!!

     

VahidDM's avatar
VahidDM
Super User
4 years ago

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
    4 years ago

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

     

     

    • VahidDM's avatar
      VahidDM
      Super User
      4 years ago

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

      Can you share a sample of your data?

       

      Appreciate your Kudos!!

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        hi still the same