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!!

     

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

     

    • VahidDM's avatar
      VahidDM
      Super User
      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!!