Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the second dimension in your chart? Try this
Max(Aggr($(v.TotalCost), [IssueDate.autoCalendar.Month], Dimension2))
What is the second dimension in your chart? Try this
Max(Aggr($(v.TotalCost), [IssueDate.autoCalendar.Month], Dimension2))
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!