topic Re: Help with Max value over dimension in App Development

Help with Max value over dimension

josemaria_cabre — Sat, 16 Nov 2024 21:10:00 GMT

Hi,
I'm having trouble finding month with max value from this set of data:

I'm looking for an expression that returns 8.28 M, but with this expression:

Max( total <[IssueDate.autoCalendar.Month]> aggr( $(v.TotalCost), [IssueDate.autoCalendar.Month]))

I'm getting 12.88 M, (which is the sum of 8.28 M + 4.6 M ...)

How should I modify this expression to return max value from all months, but without aggregating ?

Thanks in advance for your help,
Jose

Re: Help with Max value over dimension

sunny_talwar — Wed, 27 Mar 2019 14:37:34 GMT

What is the second dimension in your chart? Try this

Max(Aggr($(v.TotalCost), [IssueDate.autoCalendar.Month], Dimension2))

Re: Help with Max value over dimension

josemaria_cabre — Wed, 27 Mar 2019 14:43:36 GMT

Second dimension is [IssueDate.autoCalendar.Year], and now it works with:

Max(Aggr($(v.TotalCost), [IssueDate.autoCalendar.Month], [IssueDate.autoCalendar.Year]))

Thanks a lot for your help Sunny!