Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I need a variable with the max month:
=max(Monthdate)
But my Monthdate is: jan,feb,mar.... and with max(Monthdate) my result is 12.
Help please. Thank you!
Try this:
Pick(Max(Monthdate), 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec')
Try this:
Pick(Max(Monthdate), 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec')
That's expected, Max() will most probably return a number.
But you can try like
=FirstSortedValue(DISTINCT Monthdate, -Monthdate)
That works! Thank you!
Great solution. Thak you!