Forum Discussion
Calculate minimum value over Last 12 Months
- 6 years ago
Hello Anonymous
you can't reference a measure in a Min formula. Therefore you have to recalculate you sumamount in your new min-measure using some Summarize and addcolum. Here the solution that should work for you
MinOfSumAmount = calculate( minx( ADDCOLUMNS( SUMMARIZE( 'Table'; 'Table'[Month] ); "sum"; CALCULATE( sum( 'Table'[Amount] ); filter( all( 'Table'[Month] ); 'Table'[Month]=earlier( 'Table'[Month] ) ) ) ) ;[sum] ); all('Table') )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
Thanks, but i have getting below error for the expression:
MinTest = Calculate(MIN([Total Amount]);ALL('Date'[Month]))Errror : MIN function only accepts a column reference as the argument number 1
Hi Anonymous ,
You could try to use below measure to see whether it work or not
Measure = MINX(ALL('Date'[Month]),[Total Amount])
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.