Forum Discussion
Aggregation
is there a calculated formula to get minimum value of ON_HAND_QTY without using built-it options of aggregation.
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
- VahidDMSuper User
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!!
- AnonymousNot applicable
- VahidDMSuper User
add table name to the measure: measure = Min(table[ON_HAND_QTY])
Can you share a sample of your data?
Appreciate your Kudos!!
- FowmySuper User
Anonymous
Create a Measure:
Min_OnHand_Qty = MIN ( TableName[OnHand_Qty])- AnonymousNot applicable
- FowmySuper User
Anonymous
Share some sample/dummy data and the expected results.